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.
Had the same issue, where I was merging queries.
The issue in my instance was that the base query was expanded which resulted in duplicates in the base query.
Once the expansion was removed in the base query the merged query was fine.
So if data is okay, the issue may be caused by duplicates in the base query.
Can you explain "base query was expanded"?