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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Petanek333
Helper III
Helper III

Unknown duplicate error when refreshing dataset

Hi,

I get an error during a refresh. I get data from an Excel file and a message about duplicate value appears, see below.

Problem is, there is no duplicate value in column Product ID in Table OKAY CZ. Did you deal with this kind of message? Is there any solution? Am I missing something?

There is a relationship between the Product ID column in the mentioned table OKAY CZ and in another table. But those two columns in different tables are identical with the same count of rows. 

chyba Power BI.png

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Petanek333 ,

 

Go to your OKAY CZ query, select the [Product ID] column and go to

Home tab > Remove Rows (dropdown) > Remove Blank Rows

Home tab > Remove Rows (dropdown) > Remove Duplicates

Try and apply changes.

 

Let me know how you get on.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
Petanek333
Helper III
Helper III

Thank you guys for the solutions. Those from @BA_Pete  and @Anonymous worked well together. 

Anonymous
Not applicable

Hi @Petanek333 ,

 

Go to the model view and open 'Manage Relationships'. Delete the relationship with error and refresh again.

Below I reproduce your problem.

vstephenmsft_0-1645516998167.png

In the Manage Relationships, find the relationship with error and delete it.

vstephenmsft_1-1645517099426.png

vstephenmsft_2-1645517108548.png

Then it will refresh successfully.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Also, make sure you trim and UPPERCASE that column! If you load an otherwise identical value as lowercase, Power Query will keep it, but the data model will flag it as a duplicate. 

BA_Pete
Super User
Super User

Hi @Petanek333 ,

 

Go to your OKAY CZ query, select the [Product ID] column and go to

Home tab > Remove Rows (dropdown) > Remove Blank Rows

Home tab > Remove Rows (dropdown) > Remove Duplicates

Try and apply changes.

 

Let me know how you get on.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors