Forum Discussion

robertDTS's avatar
robertDTS
New Member
7 years ago

Data Refresh Fails, Error message claims duplicate ID value in table

I have a PBIX file where when I go to refresh my data from a SQL server the refresh eventually fails with an error message that says one of my tables contains duplicate IDs. I went to my actual SQL D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

bainmail's avatar
bainmail
Regular Visitor
7 years ago

Can you give more information on "we perform a manual on-demand refresh from the service and this solves the false reported duplicate 100% of the times." 

 

I am having the same issue and need to try this, but I am not sure what to do. Thanks.