Use the Fabric Connector

Strategy One (April 2026) adds support for Microsoft Fabric Lakehouse.

Starting in MicroStrategy ONE (September 2024), the Microsoft SQL Server Native JDBC driver is provided for the Microsoft Fabric connector.

1. Open Strategy Workstation.

2. In the Navigation pane, click Data Sources under Administration.

3. Search for Fabric and click Microsoft Fabric.

   

4. Type a Name and optional Description.

5. Starting in Strategy One (April 2026), expand the Database Version drop-down list and choose your Fabric database version.

6. Click Add new Database Connection.

   

7. Copy the Host Name from Fabric. See Retrieve the SQL connection string for more information.

8. Choose an Authentication method. Strategy supports Service Principal and Microsoft Entra ID authentication modes, as well as oAuth/OIDC single sign on using a Microsoft Entra ID to access Fabric data.

9. Create a new Database Login.

   • For Service Principal, specify the application/client ID in the userName property and secret of a service principal identity in the password property.

   • For Microsoft Entra ID, specify the Microsoft Entra ID username in the userName property and the Microsoft Entra ID password in the password property

   • For oAuth and OIDC single sign on, Fabric shares the same workflow as Azure Synapse Analytics, using the same application registered in Microsoft Entra ID and the same scope for accessing data.

     To configure OIDC, see Enable Single Sign-On with OIDC

     To configure single sign-on, see Integrate Azure SQL Database for Single Sign-On.

     To configure oAuth using Authentication Services, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

10. Test the database connection and Save.

11. You can now connect to your data when you add a new dataset.