URGENT HELP!! I keep getting error on duplicate value

[JLYT]

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

[AbhinavJoshi · Accepted solution]

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! 

[Syk]

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