Microsoft Fabric Lakehouse authentication guide

​

Prerequisites

• Access to a Microsoft Fabric Lakehouse with an SQL analytics endpoint enabled. For more information, read Create a Lakehouse in Microsoft Fabric.
• Appropriate permissions in Fabric Lakehouse for the identity you plan to use. For more information, read Workspace roles in Lakehouse.
• Tenant and Workspace settings configured to support Microsoft Entra authentication. For more information, read Microsoft Entra authentication as an alternative to SQL authentication.

​

Finding your SQL analytics endpoint connection string

1. Go to the Azure portal.
2. Navigate to your Fabric Lakehouse resource.
3. Select the ellipses ..., and click Copy connection string.

1. Under Settings, select Connection strings.
2. Copy the SQL analytics endpoint connection string.

​

Configuring the Microsoft SQL Server Load component

1. In the Connect section, open the Authentication Type drop-down, and select Username & Password.
2. To populate the Username and Password fields, choose one of the following authentication methods and configure the properties as described below: Service Principal authentication (recommended for automated processes)
   • Username: The application (client) ID of your Azure app registration.
   • Password: The client secret for the Azure app registration.
   • Connection Options:
     1. Click the configuration button next to this property to open the Connection Options dialog.
     2. From the Parameter drop-down, select “authentication”, and enter ActiveDirectoryServicePrincipal in the Value field.
     3. Add another parameter, select “selectMethod”, and enter direct in the Value field.
   Active Directory authentication (for interactive use)
   • Username: The user principal name (UPN) of your Fabric account. This is usually in email format.
   • Password: The password for your Fabric account.
   • Connection Options:
     1. Click the configuration button next to this property to open the Connection Options dialog.
     2. From the Parameter drop-down, select “authentication”, and enter ActiveDirectoryPassword in the Value field.
     3. Add another parameter, select “selectMethod”, and enter direct in the Value field.
3. In the Connection URL property, enter the following:
   jdbc:sqlserver://<SQL connection string>
   
   This string has been obtained by following the steps in Finding your SQL analytics endpoint connection string.
4. Configure other properties as required. For more information, read Microsoft SQL Server Load component.