Forum Discussion
Solved
Table Merge creates duplicate records
Hi Folks, I am stumped. I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on...
The problem lay with the Data.
The LEFT JOIN functionality of PowerBI works perfectly.
I know this post is old, but this may help others in the future:
Create an Index Column before the merging.
This will mark each row with a unique sequential number.
When the duplicate happens, it will duplicate the number as well.
After the merging, select the Index Column and remove duplicates.
Remove Index column.
Thank you, this is the only thing that worked for me! The index also makes it easy to spot where data has been deleted eronously. I plan on added one to all of my datasets from now on.