Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Duplcated 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' 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."

I checked the table and there is no duplicated. Anyway I went to the Power Query and deleted duplicated values, but I still get the error.

The only way not to get it, is to edit the relation between the tables, I can't make a 1:1 relation with this table (as it really has duplicated values).

Any ideas?

Thanks!

Need Help

4 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    7 years ago

    Have you tried to search "00119341460" in Robot_ID Column?

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

      • mussaenda's avatar
        mussaenda
        Community Champion
        7 years ago

        Did you discover why they are duplicating? like those two rows are completely identical?