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...
On many occasions I've also come across and been able to clear this issue via issuing an additional manual refresh but today a manual refresh wouldn't clear it.
Finally found my issue was caused by a Upper/Lower CASE SENSITIVITY ISSUE...
I use a bridge table to create a usable relationship between two *:* tables (instead creates a 1:* in both directions) and it seems I had a repeated value (only differing in case) when merging the two sources for the bridge. Power query would properly perform the merge when I was in the "Transform Data" window but I think it became case sensitive when running a refresh of the entire file...
Weird right? Anyway; hope this helps someone out there.