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...
Need Help
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
Icon for Community Champion rankCommunity Champion
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    One row is the correct row with the current data, the other one looks like an old row (has the data of a previous refresh, with old data from a few hours ago).

    I guess is something with the ODBC, but I'm still looking at it.