Forum Discussion
Duplicate Value
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!
Hi. I think I remember two times this happend to me with different cases. The first one was having null or blank values that won't let you create the relationship and will show you like duplicates. The second one is in case the column is a text column. If you have text column first modify the column to upper o lower case before removing duplicates to be sure you are not having values like "a35728" that won't remove if you have another like "A35728".
Hope any of those helps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Hi Anonymous ,
You could remove the duplicate rows in query editor and try again.
Best Regards,
Cherry
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!
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.
