Power Platform Community Forum Thread Details

Environment

Dataverse (Dynamics 365) → ASL → ADLS Gen2 → Databricks → EDW

Sync interval: 30 minutes

Change Tracking: Enabled on all affected tables

Issue

We are using Azure Synapse Link to sync Dataverse tables to ADLS Gen2. We have a recurring issue where updates to existing records are not being synced while new record inserts sync correctly.

The issue occurs silently — no errors in EntitySyncFail folder, no alerts from ASL, and SinkModifiedOn continues showing recent timestamps giving a false impression that sync is healthy.

Business Impact:
A sales opportunity marked as Won in CRM continued showing as Open in our EDW due to the update never landing in ADLS, causing incorrect revenue reporting.

What We've Verified

Change Tracking enabled on all affected tables

ASL profile active and running

No errors thrown anywhere in the pipeline

Current Workaround

Unlink → Relink affected table → Full resync → Reprocess all layers. This fixes it temporarily but is not sustainable as we don't know when it will break again.

How can we proactively identify and resolve this synchronization issue before it impacts the reporting layer?

Thanks in advance.

Categories:

Microsoft Dataverse with Power Apps