Forum Discussion
Duplicate Error
Hello all, Since yesterday, I am having an error concerning a duplicate value. However, when I look it up in the source file, there is no duplicate whatsoever. If I delete the row that PowerBI id...
RV I could be wrong here, but I think you need to make sure you don't have any "blanks" in your data. Have you confirmed this?
Thank you for answering quickly. I selected the column in Excel and removed duplicates (no duplicates here). Checked the list and no blanks either.
Ok, so the issue is not from the source data but from the Merge. Before merging the queries it seems like it's fine. Once I add the new columns after merging, I get the duplicate. This happened yesterday and today - it used to never happen before.