Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,200 questions
Synapse Link for F&O Not refreshing
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Manuel Alejandro Estrada Doñes
20
Reputation points
Hi MS Team
I have an Azure Synapse Link implementation that is set to Synchronize every 15 min, but for some reason the column Last Synchornized Date never change and the data is not updating, not see any error message or notification.
Do you know where i can check this issue or know I missing some permission or role.
Regards.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 80 Reputation points Microsoft Vendor2025-02-21T07:36:19.9266667+00:00 Hi @Manuel Alejandro Estrada Doñes
Thanks for posting your query!
Since your Azure Synapse Link for Dataverse is active but not syncing, here are key troubleshooting steps:
Check Change Tracking
Synapse Link relies on Dataverse Change Tracking to detect updates. If it's stuck, data won’t sync. Disable and re-enable Change Tracking in Power Apps > Tables > Settings and restart the link.
Review System Jobs in Power Apps
Go to Advanced Settings > System Jobs and check for stuck export jobs. If found, cancel and restart the sync.
Check Permissions
The user or identity running the synchronization should have the Contributor or Data Reader role on both the Azure Synapse and Dynamics 365 F&O resources to enable successful data sync. Additionally, verify that the Synapse Link service has the correct permissions to interact with the target storage.
Check Microsoft Service Status
Visit Azure Status and Power Platform Health for possible service outages.
If none of these steps work, consider opening an Azure Support Ticket for further investigation.I hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
Sign in to comment
Sign in to answer