Resolving Azure Synapse Setup Issues: Inactive Status for Dynamics 365 Finance and Operations Tables

After completing the installation setup required to synchronize data from Dynamics 365 for Finance and Operations to Azure Synapse, you may encounter a situation where tables/data have not yet reached the Synapse workspace. If you examine the Dataverse connection, you will notice that each of those tables has a status indicating that the initial synchronization is in progress, as depicted in the screenshot below.

 

The primary reason for this issue could be an incorrect platform version of Dynamics 365 for Finance and Operations. To resolve this, you need to apply the minimum Proactive Quality Upgrade necessary to surpass a certain version number. Once the update is applied, you are good to go, and the synchronization of schema and data will automatically resume.

 

The column "Synch status" (3rd from the left side) displays the status as "Active" when it is in a healthy condition.