Forum Discussion
Solved
Refresh Error: Contains Duplicate Value
Hello PowerBI community, I am in need of help refreshing my daily sales report. I have categories for each item in the report and needed to change an items sales category in the excel file to ma...
Solution!!!
I went into query editor and removed the index column with the duplicates then re-added a new index column with new numbers.
Hi 10656645 ，
Pls test operation like the below:
1. Go to Model on the left bar and then click 'Manage relationships' under the 'Home' menu.
2. Select which relationship is causing the issue and then delete it.
3. Open Power Query and then go to the 'Add Column' menu and click 'Index Column From 1'
4. Refresh all queries and then click 'Load & Apply'.
Similar question refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Solution!!!
I went into query editor and removed the index column with the duplicates then re-added a new index column with new numbers.