Unknown duplicate error when refreshing dataset

[Petanek333]

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. 

[ptpaton]

Error occurred when I tried to convert from direct query to import.  Duplicate values on a column that was an identity column used as a primary key in SQL server, so I knew there were no nulls or duplicates.  The duplicates were created because I merged a query and expanded a column.  Apparently direct query can handle this but import can't.  Removed the expanded column, converted to import, remerged the query and reexpanded the column did the trick.

[Petanek333]

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

[Anonymous]

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.

[Anonymous]

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 · Accepted 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