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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I just did it again and see that there are 2 records with the same ID in the table.

When checking in the database there is only one record. Is a MongoDB and I'm using an ODBC connector to bring it to PowerBI.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
6 years ago

Hi Anonymous ,

You could remove the duplicate rows in query editor and try again.

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!

    • Maisie's avatar
      Maisie
      New Member
      3 years ago

      1. The rootcause is the table which has been automated related to other tables which you don't know. Click the table to check all of its relationship, then delete the unwanted relationships. After that, everything works normally.