Forum Discussion

JLYT's avatar
JLYT
Frequent Visitor
3 years ago
Solved

URGENT HELP!! I keep getting error on duplicate value

Hi,

I keep getting the below error when refreshing the data. However, when I look at the table in Power Query, the whole column is unique. The database that I am pulling from is also saying there is no duplicate record. Does anyone know how to fix this please?
contact

Column '_id' in Table 'contact' contains a duplicate value '64c026eebe0e216b3cec7552' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Thanks
Jennifer



Need Help
Show and Tell
  • AbhinavJoshi's avatar
    AbhinavJoshi
    3 years ago

    Hello JLYT. In power query editor, right click on the column (_id), and remove duplicates. To be on the safe side, after that click on Remove Errors. Ensure that you have these options enabled as they can help you identify unique/error values. Hope it helps! 

     

     

2 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    In Power Query, right click the _id column and deduplicate. It should fix your issue.

  • AbhinavJoshi's avatar
    AbhinavJoshi
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Hello JLYT. In power query editor, right click on the column (_id), and remove duplicates. To be on the safe side, after that click on Remove Errors. Ensure that you have these options enabled as they can help you identify unique/error values. Hope it helps!