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