Forum Discussion
Data Refresh Fails, Error message claims duplicate ID value in table
We have about 20 Power BI app workspaces scheduled to refresh on a regular bases... we get the false duplicate error message about 1 in every 100 refreshes. For those with the false duplicate error reported, we perform a manual on-demand refresh from the service and this solves the false reported duplicate 100% of the times.
It has been confirmed as a "false" duplicate error, but must be some other error.
Maybe its something to do with not clearing the table completely before reloading.
We have also seen the same behavior with PBI desktop, and again just doing another immediate refresh the reported duplicate is gone. Weird
This "false duplicate" error is still occurring for us. However it is increasing in frequency, we are now seeing this in more and more PBI apps, and the false error is happening about 20% of the time during scheduled refreshes. We are now seeing it reported as a problem experienced by an increased number of content producers too.
We can't reproduce the false error on-demand which limits our ability to troubleshoot. We are sharing this information here in hopes of keeping MS and the community aware of the problem.
We currently ignore the false error messages as it disappears with the next refresh cycle. However it appears the symptom is much more broad, varied, and not localized to our tenant or premium capacity.