Azure Synapse Link: Dataverse connection id is not valid for this user

[MVerschuuren]

Hello,

I'm trying to Refresh Fabric tables in Azure Synapse Link, but I keep running into the following error:

A back end error occured. The Fabric to Dataverse connection id ****** is not valid for this user. Please check that you have access to this connection, and that the connection is connected to this organization, with URL acc-*****.crm4.dynamics.com. You can try again, if this issue persists please contact support.

Correlation Id: ******

Session Id: ******

My colleague who set up the connection can refresh tables without any problems. Does anyone know why I cannot refresh tables?

We've compared al rights between users, there are no known differences at this moment. We've also checked all Prerequisites from the learn Microsoft page (https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric).

[goflse]

I have teh same issue. I created the link and was Owner of the connection but still get the same error. Added my colleaguues as well without success.

[MVerschuuren]

Yes, this solved the issue! Thanks to both replies. 

[MVerschuuren]

Thanks for the replies. I will be working with said colleague again tomorrow, will reply after that. 

[Anonymous]

Hi @MVerschuuren 

The document lists the error you encountered, please go to Troubleshooting common issues section: Link your Dataverse environment to Microsoft Fabric and unlock deep insights - Power Apps | Microsof...

This error message indicates that the user selecting the Refresh Fabric tables option in the Azure Synapse Link page doesn't have the required permissions. This error might be shown even when the user has access to the tables in Dataverse and is a system administrator.
The link to Fabric wizard in Power Apps creates a data connection at the time of creating the link to Fabric. This data connection uses credentials of the user, it's possible that:
- The password of the user who created the connection has changed or has expired.
- The user account of the user who created the Fabric link is inactive.
- The user performing the Refresh Fabric tables option doesn't have access to the data connection. More information: Secure data and grant access to other users

Best Regards,
Jing
Community Support Team

[FabianSchut · Accepted solution]

Hi, did your colleague who set up the connection also added you as a user? https://learn.microsoft.com/en-us/fabric/data-factory/data-source-management#manage-users