Forum Discussion

Petanek333's avatar
Petanek333
Helper III
4 years ago
Solved

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...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.