Connecting to Fabric database using workspace identity

[g3kuser]

Hi,

I am trying connect to Fabric Database from Notebook by using pyodbc and jdbc library. I was able to successfully authenticate via Service Principal that required me to set secret. Our infra would prefer to use Workspace Managed Identity as authentication so as to avoid secret rotations. I tried different options but getting error on Authentication option as ActiveDirectoryManagedIdentity,ActiveDirectoryMSI but got error as Unknown realm choice.

I noticed the options allowed in Fabric database to include only 

ActiveDirectoryInteractive, ActiveDirectoryServicePrincipal, or ActiveDirectoryPassword.

Authentication in SQL database - Microsoft Fabric | Microsoft Learn

Any solution for usage of workspace identity?

Thanks,

Gayatri

[v-ssriganesh · Accepted solution]

Hi @g3kuser,

Thank you for reaching out to the Microsoft fabric Community Forum.

We understand you’re looking to connect to a Fabric Database from a Notebook using Workspace Managed Identity for authentication, as this would better align with your infrastructure's preference to avoid secret rotations.

At the moment, Workspace Managed Identity authentication is primarily supported for accessing external data sources (e.g., Azure Data Lake Storage Gen2 and other Microsoft Entra (formerly Azure AD)-enabled services).

Using Workspace Identity to authenticate directly with Fabric databases (e.g., Data Warehouse, Lakehouse SQL Endpoint) is not currently supported.

For connecting to Fabric databases, the currently supported authentication methods are:

• ActiveDirectoryInteractive
• ActiveDirectoryServicePrincipal
• ActiveDirectoryPassword

For reference:
Workspace identity - Microsoft Fabric | Microsoft Learn
Authenticate with Microsoft Fabric workspace identity - Microsoft Fabric | Microsoft Learn

We recognize that support for Workspace Identity in database connections would be a valuable feature. We encourage you to submit your feedback or upvote existing ideas in the Fabric Ideas forum. Customer feedback is crucial in shaping future updates, and your input could help prioritize this feature in upcoming releases. Below is the link for the Fabric Ideas forum:
Home

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.