Connecting to Fabric database using workspace identity

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.