Forum Discussion

DataGuy2016's avatar
DataGuy2016
Advocate IV
9 years ago
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...
Need Help
  • DataGuy2016's avatar
    DataGuy2016
    9 years ago

    The problem lay with the Data.

     

    The LEFT JOIN functionality of PowerBI works perfectly.

othmanalazzam's avatar
othmanalazzam
Advocate I
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I work with very extensive datas sheets and as soon as I tried this solution (that works pretty well) the uptade started to take hours to be conclude, thats the only issue Im having right now... Any clues about that?