This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(265.6, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Successfully generated a summary
I am experiencing an issue where records are not syncing from Dataverse to Azure Database intermittently, specifically for the Payment (evx_payment) entity. The affected records only sync when the customer manually updates them from CRM. I have over a million records in the affected entity. I am using the DataverseCDMToSQL DataFlow in Synapse Analytic Studio to push the data to the Azure DB.
Can anyone please help me with this error? thank you so much in advanced.
@Gustavo Mercado (LTIMINDTREE LIMITED) Thank you for reaching out.
If it is generating an error, could you please describe the full error.
Copy Dataverse data into Azure SQL using synapse link. Use the Azure Synapse Link to connect your Microsoft Dataverse data to Azure Synapse Analytics from Dataverse to Azure SQL.
Regards,
Oury
No error message
For example, there are 1,000,000 records in Dataverse but finally in the database when i check 1000 records are missing.
I really don't know why this happens?