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.

powergirl's avatar
powergirl
New Member
8 years ago

I got the same problem.

Source table is an daily order table with duplicated rows, i.e. SKU ID and merged with another matching table with unique rows of SKU ID, and created randomly duplicated rows.

 

Whatever I tried to remove duplicates or aggregated by median still not get the correct final data.

 

My order data could get up to 20K rows and it's easily get wrong while I merged the tables.

 

That is so annoying.

 

Hope POWER BI experts can really solve this problem.

 

Thanks.

MS1986's avatar
MS1986
Regular Visitor
8 years ago

Hi, is there anyone who can help with this? I have the same issue and there seems to be no solution for it apart from Table.First, but this function slows down the query...