Synapse Link for F&O Not refreshing

Manuel Alejandro Estrada Doñes 25 Reputation points
2025-02-21T00:36:55.9966667+00:00

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.

User's image

Regards.

Azure Synapse Analytics
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,378 questions
{count} votes

1 answer

Sort by: Most helpful
  1. J N S S Kasyap 3,780 Reputation points Microsoft External Staff Moderator
    2025-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.  

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.