Forum Discussion
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...
The problem lay with the Data.
The LEFT JOIN functionality of PowerBI works perfectly.
Can you explain "base query was expanded"?
he meant the other query that you are merging your data with
so if you are in Table A and trying to merge data with Table B, if Table B has duplicates it will result in a duplicates in your Table A after you expand the results, so it's better to have Table B cleaned from duplicates first.