Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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
Proud to be a Datanaut!
Thank you guys for the solutions. Those from @BA_Pete and @Anonymous worked well together.
Hi @Petanek333 ,
Go to the model view and open 'Manage Relationships'. Delete the relationship with error and refresh again.
Below I reproduce your problem.
In the Manage Relationships, find the relationship with error and delete it.
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.
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.
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
Proud to be a Datanaut!
Check out the July 2025 Power BI update to learn about new features.