Power Platform Community Forum Thread Details

Hi,
one year back, I have added synapse link for dataverse to get the data and all seems worked fine. however, when now , i am trying to add new tables using same synapse link or different link in different enviornment goes into queued state and it can't see the data in synapse environment. Any idea how to solve this issue?

Categories:

Microsoft Dataverse with Power Apps

Hi! It sounds like you're encountering a common issue with Azure Synapse Link for Dataverse. Here are some steps to troubleshoot and resolve the problem:

Check Permissions: Ensure that the necessary permissions are correctly set for the Synapse Workspace, storage account, and Dataverse environment. You need roles like Dataverse System Administrator, Synapse Administrator, and Storage Blob Data Contributor.
Networking Configuration: Verify that public network access is enabled for the linked storage account. If you're restricting public access, make sure managed identities are properly configured.
Region Mismatch: Ensure that the Synapse Workspace, storage account, and Power Apps environment are all in the same Azure region.
Enable Change Tracking: Make sure the tables intended for export have the Track changes property enabled. This is crucial for data synchronization.
Admin Mode: Check if your Power Platform environment is in admin mode. If it is, all services including Azure Synapse Link will be temporarily paused.
Resource Contention: If your Synapse workspace is under heavy load, the pipeline may be queued due to resource contention. Verify if other pipelines or activities are running in the workspace .
Review Troubleshooting Guide: Microsoft provides a detailed troubleshooting guide for Azure Synapse Link for Dataverse. This guide covers various error conditions and their resolutions.