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!

sabirguiri's avatar
sabirguiri
Frequent Visitor
6 years ago

The best practice that I would suggest is that you don't delete the rows but do the following.

 

1. Go to Model on the left bar and then click 'Manage relationships' under the 'Home' menu.

2. Select which relationship is causing the issue and then deleted it.

3. Open Power Query and then go to the 'Add Column' menu and click 'Index Column From 1'

4. Refresh all queries and then click 'Load & Apply'.

 

This worked well for me without having to delete records.

 

Sabir