topic Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication in Data Warehouse

Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

Abhishek_MAQ — Mon, 01 Sep 2025 06:23:41 GMT

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 and deploying the solution on an Azure Container App, the authentication no longer works.

Is Managed Identity currently supported for authenticating to Fabric Lakehouse?
If not, what are the recommended alternatives or best practices for secure authentication in this scenario?

Appreciate any guidance on this.

Thanks!

Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

Shahid12523 — Mon, 01 Sep 2025 06:55:38 GMT

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:

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.

Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

v-lgarikapat — Tue, 02 Sep 2025 10:18:40 GMT

Hi Abhishek_MAQ ,

Thanks for reaching out to the Microsoft fabric community forum.

Shahid12523

Thanks for your prompt response

Abhishek_MAQ

I wanted to follow up and confirm whether you’ve had the opportunity to review the information provided by Shahid12523 If you have any questions or need further clarification, please don’t hesitate to reach out.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

v-lgarikapat — Fri, 05 Sep 2025 06:06:37 GMT

Hi Abhishek_MAQ ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

v-lgarikapat — Mon, 08 Sep 2025 06:50:43 GMT

Hi Abhishek_MAQ ,

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

Re: Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication

simontaylor — Fri, 06 Feb 2026 17:37:48 GMT

No cert or client secret is required?