Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
10656645
New Member

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 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!

1 ACCEPTED 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. 

10656645_0-1651673666871.png

 

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

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:

https://community.powerbi.com/t5/Desktop/Refresh-error-quot-contains-duplicate-value-and-this-is-not... 

https://community.powerbi.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-... 

 

 

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. 

10656645_0-1651673666871.png

 

aj1973
Community Champion
Community Champion

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors