Forum Discussion

Abhishek_MAQ's avatar
Abhishek_MAQ
Microsoft Employee
11 months ago
Solved

Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

Hello, I was able to connect to the Fabric Lakehouse SQL Analytics endpoint using pyodbc along with DefaultAzureCredential for authentication in local. However, after switching to Managed Identity a...
Data Warehouse
  • Shahid12523's avatar
    Shahid12523
    11 months ago

    Managed Identity is not yet supported for connecting from Azure apps (like Container Apps) to Fabric Lakehouse SQL Analytics.

    ✅ Use Service Principal (SPN) with Microsoft Entra ID instead:

    Register an SPN in Entra ID.

    Enable “Service principals can use Fabric APIs” in tenant settings.

    Grant the SPN workspace + item-level access (e.g., “Read all SQL endpoint data”).

    Connect with Authentication=ActiveDirectoryServicePrincipal.

     

    👉 Managed Identity works in Data Factory/Synapse pipelines, but for app workloads, SPN is the recommended secure option.

Shahid12523's avatar
Shahid12523
Community Champion
11 months ago

Managed Identity is not yet supported for connecting from Azure apps (like Container Apps) to Fabric Lakehouse SQL Analytics.

✅ Use Service Principal (SPN) with Microsoft Entra ID instead:

Register an SPN in Entra ID.

Enable “Service principals can use Fabric APIs” in tenant settings.

Grant the SPN workspace + item-level access (e.g., “Read all SQL endpoint data”).

Connect with Authentication=ActiveDirectoryServicePrincipal.

 

👉 Managed Identity works in Data Factory/Synapse pipelines, but for app workloads, SPN is the recommended secure option.

simontaylor's avatar
simontaylor
Microsoft Employee
6 months ago

No cert or client secret is required?