Accessing Fabric SQL endpoint using managed identity from Azure Synapse Analytics

Hi Avadh , Thank you for reaching out to the Microsoft Community Forum.

This is likely cause your Synapse workspace's system assigned managed identity doesn’t have the required item-level permission on the Fabric Lakehouse. Microsoft Fabric requires that any identity, including managed identities be explicitly granted access to the Lakehouse itself, not just at the workspace level.

Go to Manage access in your Lakehouse and manually add the object ID of your Synapse managed identity. Assign it the Read all SQL endpoint data permission. Without this, the authentication will fail, even if everything in your linked service is configured correctly.

Also, the red cross on AutoResolveIntegrationRuntime in your screenshot is a non-blocking UI status issue. Since you're using a managed identity, IR health doesn't impact authentication in this context and can be ignored, it doesn't affect authentication when using managed identity.

Manage access for SQL databases in Microsoft Fabric with workspace roles and item permissions | Microsoft Fabric Blog | Microsoft Fabric

Give Users Access to Workspaces - Microsoft Fabric | Microsoft Learn

Workspace roles and permissions in lakehouse - Microsoft Fabric | Microsoft Learn

What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn