Recently for some of our Dataverse environments, we found duplicate records getting created (same GUID) for Notes and Work Order Incident tables in the corresponding CSV files.
Here we were using In place update – In-place updates vs. append-only writes
This was causing the Power BI reports built on top of it to fail.
On raising the ticket, the Microsoft Support team mentioned that this is a known bug for certain regions, and they immediately ran the de-duplication scripts in the background which quickly fixed the issue for us. Also, they specified they will be deploying the fix for the issue in the coming days.
Hope it helps..
Hi Nishant,
Fyi,
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-delta-lake
LikeLike