How to create a Linked Service in Azure Synapse for Fabric Warehouse

[Stevek-09]

I want to create a linked service in my Azure Synapse Analytics workspace to sink data in a Fabric Warehouse. 

The synapse workspace has a manged virtual network. I've already grant in the Fabric workspacethe role contributor to the service principal of Synapse. That service principal also has a secret certificate. 

The "Service principal can use Fabric APIs" in the Tenant Setting has been enable for the Synape Service Principal.

When I chose my fabric warehouse, I have this error message as you can see below : 

{"requestId":"b037e0cb-a6dd-4295-a71a-e1249e2d4255","errorCode":"InsufficientScopes","message":"The caller does not have sufficient scopes to perform this operation"}

Can someone please help me with that?

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare · Accepted solution]

@Stevek-09

Thanks for your patience and Sorry for the inconvenience caused here.

@Stevek-09, please don't hesitate to submit a support ticket. please raise a support ticket with above deatils this will allow a dedicated team to investigate and provide a resolution. When several users report the same incident, Microsoft will raise the priority of the incident and respond quickly

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric Community Support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[Stevek-09]

I've correctly set up role assigments and Tenant Settings. 

Regarding API permissions, I've set up the following : 

Still It doesn't work.

Therefore I don't see the "Fabric.ReadWrite.All" in the permissions.

[Stevek-09]

Hi @v-prasare ,

Everything is correctly set up regarding Role assigments and Configurin Tenan Settings.

I've tried to assign API Permissions but it still doesn't work :

Though I don't see the Fabric.ReadWrite.All. 

Any other solution?

[v-prasare]

Hi @Stevek-09,

Thanks for reaching MS fabric community support.

This is likely a misconfiguration in Azure Active Directory or the permissions granted to the service principal. Can you please try below troubleshooting steps and let me know if these helps resolve your issue?

Assigning Appropriate API Permissions: Ensuring that the service principal has the necessary API permissions, such as Fabric.ReadWrite.All, and that these permissions have been granted admin consent.

Configuring Tenant Settings: Verifying that tenant settings in the Power BI Admin Portal allow service principals to use the necessary APIs and interact with data.

Role Assignments: Confirming that the service principal has the correct role assignments, like the Contributor role, within the relevant Azure and Fabric workspaces.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[xueSabina]

I have created linked service for Fabric Lakehouse in synapse analytics, but can not create linked service for Fabric warehouse. The Error Message shows: The caller does not have sufficient scopes to perform this operation.

According to the Doku, the steps to create a linked-service for Fabric Lakehouse are exactly the same as the steps to create a linked-service for Fabric Warehouse, but only the "message": "The caller does not have sufficient scopes to perform this operation" is displayed when connecting to Fabric Warehouse.
I tried to connect to Fabric Warehouse using MSSQL, and everything was able to be read normally. I don't understand what went wrong.