March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 match what accounting has in their reporting. When I went to refresh PowerBI with this change, I received an error stating that the table "Daily Sales" contains a duplicate value and this is not allowed.
I attempted a few things. One being clearing the cache in the query editor (didnt work) and the other changing the relationships up which also didnt work.
Does anyone know anything else I can try without having to change the sales category back to the wrong one in the excel file?
Thank you!
Solved! Go to Solution.
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.
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
38 | |
37 | |
33 | |
20 |