Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Duplicate Value

Hi,  Everything worked good and suddently I get an error when trying to refresh the data set. The error says: "Column 'robot_id' in Table 'bi_steady_updates' contains a duplicate value '00119341460...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I tried to delete duplicated in the Power Query, but still got the same error when refreshing.

    Finally I have deleted the row in the database as a workaround and that let me refresh now.

    Thanks!

jayaxe's avatar
jayaxe
Advocate I
5 years ago

I found another root cause why this happens and it's the "Auto-detect relationship" function being the culprit. As my company has many entities around the world, I have multiple tables to append/combine. The "Auto-detect relationship" function which was turned on by default, connected some tables without my knowledge (e.g. Customer Name (2) to Invoice No. (2) Customer Name). At first everything was ok, since there was no duplication and the relationship was fine. But the moment there was a duplicate Customer Name in the unique list table, this auto created relationship now becomes "Many to Many". 

 

Therefore the solution is to delete all these unneccesarily created relationships and also turn off  the "Auto-detect relationship" function. Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I don't have any relationship between the table still detected wrong relation and making errors.This helped me

    Thanks alot.