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.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi DataGuy2016,

 

According to your description, I just tested it in my environment. The Merge Queries option works all fine for me without the issue.

 

I assume the issue is with your data. Could you post your table structure with some sample data which can reproduce the issue? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

In addition, here is a similar thread for your reference.:smileyhappy:

 

Regards

DataGuy2016's avatar
DataGuy2016
Advocate IV
9 years ago

Hi,

 

The LEFT JOIN table Merge is creating duplicate records from the LHS table. 

 

I understand what a LEFT JOIN is. 

 

My LHS table only has unique rows.  Why is PowerBI creating duplicate records?  These are 100% identical in every respect.

 

 

 

SQL JOINS