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.

baronraghu's avatar
baronraghu
Helper III
6 years ago

Hi All,

 

I having similar issue, Below are the tables and the output after using full outer join

 

Table1 

image.png

 

Table 2

image.png

 

Merging query screenshot

image.png

 

Merged table with duplicate entries- actually it copies table 2 for each entry of table 1

image.png

 

Any solution