Forum Discussion
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...
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.
I should NOT have said it solves the problem... it just proves that there is not really a duplicate ID 100% of the time.
The problem is still happening for us and how at a much greater frequency.