Cannot query data from Fabric Lakehouse SQL Analytics Endpoint using Service Principal (only schema)

Hi JGAlltricks ,

Thank you for reaching out to the Microsoft Community Forum.

Hi Shahid12523 , Thank you for your prompt response.

Hi JGAlltricks , In addition to Shahid12523  response, I am adding some more points.

Please check the below things to fix the issue

1. Please check the Fabric tenant settings “Service principal can use Fabric APIs” is enabled. This is required for Service principal to interact with Fabric resources.

2. Please assign the Service Principal to a workspace role Contributor or Member via the Manage Access option in the workspace.

3. Use the Lakehouse sharing UI to explicitly grant the Service principal, ReadData on the SQL Analytics Endpoint and ReadAll on the Lakehouse.

4. Use T-SQL to Grant SELECT, Once the Service principal has control plane access, you can grant data-level access using T-SQL.

GRANT SELECT ON [schema].[view_name] TO [service_principal_name];

Note: You cannot manually create users with CREATE USER unless you are using the FROM EXTERNAL PROVIDER clause and have Directory Readers role in Entra ID.

5. Use the below query to check what permissions the Service principal has.

SELECT * FROM sys.fn_my_permissions(NULL, 'DATABASE');

Note: Service principals cannot perform DCL operations like GRANT, REVOKE, or DENY themselves. These must be executed by a user with elevated permissions. Service principals cannot trigger implicit user creation, so check the user identity exists before assigning permissions.

Please refer Microsoft articles and community threads.

Authentication in SQL database - Microsoft Fabric | Microsoft Learn

Service Principals in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn

SQL Granular Permissions - Microsoft Fabric | Microsoft Learn

Solved: How to Grant Access to an Individual Table/View in... - Microsoft Fabric Community

Solved: Fabric Lakehouse Permissions - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh