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

ptpaton's avatar
ptpaton
Frequent Visitor
1 year ago

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.