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

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.