Forum Discussion

10656645's avatar
10656645
New Member
4 years ago
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...
Need Help
  • 10656645's avatar
    10656645
    4 years ago

    Solution!!!

     

    I went into query editor and removed the index column with the duplicates then re-added a new index column with new numbers. 

     

aj1973's avatar
aj1973
Community Champion
4 years ago

Hi 10656645 

Have you tried to refresh the report in your desktop? Before that delete all relationships to that excel sheet and refresh, then relate the table back in.