Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
    7 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
5 years ago

Hello Viewers ,

I am Facing Error when i use PBI Cleaner Tool -

" Column 'Key' in Table 'StorageSize' contains a duplicate value 'Distinct number of units Material.MATERIAL' 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. "