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!

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.