Fabric Connection Guide

Learn More About Fabric

If you’d like to explore how Fabric can support your data strategy, reach out to your Coalesce account manager or contact our sales team.

Before You Begin

Fabric

• You must an Azure administrator or be able to grant admin permissions.
• Have a table in Fabric ready to add to Coalesce.

Coalesce

• Must be a Coalesce org admin.
• For Coalesce, have a Project with version control.
• Any users need to be added to Coalesce by either adding them manually by the org admin or setting up SSO to Coalesce so they are added automatically.

Get Your Fabric SQL Connection String

1. Log into your Fabric app.
2. Find the workspace you want to connect to.
3. Select the three dots next to the warehouse name and then select Copy SQL connection string.
4. You’ll need this to connect Fabric and Coalesce.

Create an Azure App Registration

You’ll create a Service Principal to use in Coalesce.

Register a New App

1. Create a new app registration in Azure.
2. Give the app a name.
3. Set the supported account types based on your security preferences.
4. Leave the Redirect URI blank and click Register.

Add Permissions

Go to API Permissions for the app you just created an add the following permissions:

Azure SQL Database

• app_impersonation - Access Azure SQL DB and Data Warehouse. Set to application.
• user_impersonation - Access Azure SQL DB and Data Warehouse. Set to delegated.

Create App Role

1. Go to App roles.
2. Click Create app role.
3. Configure the following options:
   1. Display Name
   2. Allowed member types: Both
   3. Value: allowedMemberTypes
   4. Description

Certificates and Secrets

1. Go to Certificates & secrets.
2. Click New client secret.
3. Give it a name and set the expiration.
4. Copy the Value and Secret ID.

Configure Fabric

1. Go to the settings (cog) .
2. Then go to Governance and insights > Tenant Settings > Developer Settings.
3. Check Service principals can use Fabric APIs and Service principals can call Fabric APIs.
4. Choose if you want it to apply to the entire organization or certain groups.

Workspace Settings

1. Go to the Workspace and click Manage Access.
2. Start typing the name or ID of the service principal you created.
3. Set the role to Contributor.

Connect to Coalesce

1. Create a new Project in Coalesce. Review the instructions for Create a Project.
2. Give the Project a name and change the platform to Fabric.
3. If you have a Version control repository URL, you can add it. You can also skip it for now and ignore the warnings.
4. In the Project you just created, click Create Workspace.
5. Give Workspace a name and click Create.
6. Open the Workspace Settings.
7. Add the SQL connection string in the Fabric Connection Account. Remove the .datawarehouse.fabric.microsoft.com.

1. Click User Credentials and click Edit.
2. Enter the Client ID (Secret ID) and Client Secret (Value).
3. Click Test Connection and then Save.