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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I am having the same problem with my data.  And no, I do not understand your answer to "expand as an aggregate," will you please clarify?

 

I know this is an old thread, but if someone else is still reading this thread and would like to offer help, I appreciate it!

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI JR,

 

Thank you for the response.  Could you send me an email at [email protected].  I want to talk with you more and share a sample file, but I can't figure out how to upload an excel file here.

 

Thanks,

 

Tera