Skip to main content

Connect Microsoft Fabric

Supported authentication methods​

The supported authentication methods are:

  • Microsoft Entra service principal
  • Microsoft Entra password

SQL password (LDAP) is not supported in Microsoft Fabric Data Warehouse so you must use Microsoft Entra ID. This means that to use Microsoft Fabric in dbt, you will need at least one Microsoft Entra service principal to connect dbt to Fabric, ideally one service principal for each user.

Microsoft Entra service principal​

The following are the required fields for setting up a connection with a Microsoft Fabric using Microsoft Entra service principal authentication.

FieldDescription
ServerThe service principal's host value for the Fabric test endpoint.
PortThe port to connect to Microsoft Fabric. You can use 1433 (the default), which is the standard SQL server port number.
DatabaseThe service principal's database value for the Fabric test endpoint.
AuthenticationChoose Service Principal from the dropdown.
Tenant IDThe service principal's Directory (tenant) ID.
Client IDThe service principal's application (client) ID id.
Client secretThe service principal's client secret (not the client secret id).
Loading table...

Microsoft Entra password​

The following are the required fields for setting up a connection with a Microsoft Fabric using Microsoft Entra password authentication.

FieldDescription
ServerThe server hostname to connect to Microsoft Fabric.
PortThe server port. You can use 1433 (the default), which is the standard SQL server port number.
DatabaseThe database name.
AuthenticationChoose Active Directory Password from the dropdown.
UserThe Microsoft Entra username.
PasswordThe Microsoft Entra password.
Loading table...

Configuration​

To learn how to optimize performance with data platform-specific configurations in dbt, refer to Microsoft Fabric Data Warehouse configurations.

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Loading