Forum Discussion
Petanek333
Helper III
Helper IIIUnknown 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...
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
BA_Pete
Super User
Super UserHi 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