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...
Hi,
I had this issue with my SSAS Tabular, and have solved by "Processing it in Full"
I'm sure you can apply this with your PBI refresh.
Cheers,
Basia
Alternatively remove the Unique Key constraint within PBI (SSAS has this feature)