Forum Discussion
Table Merge creates duplicate records
The problem lay with the Data.
The LEFT JOIN functionality of PowerBI works perfectly.
Hi people.
I've been looking for this issue with no luck as well until I founded a valid work around.
the work around goes like this ::
-Merge your sheets as you like (you don't have to merge on more than one column, one is fine).
-Add index column
-Expand your merged column (this will create duplicate values, the main issue we're looking into).
-since the values in the "index column" were purely unique, now Remove duplicates using index column.
-and now your data is back to original as it was inteded to be.
hopefully you'll reply but when I do this ...it does indeed eliminate the duplicates in the 2nd table added
but after removing the dups in the index, now the original table has dups
here is sample data ..trying to merge "ycr" and "integrated"and end up with "goal"