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.
Many Many thanks! I had the exact sa;e problem and I indeed found duplicated values in one of my tables!
I was joining on the the text field and it was creating duplicates. Once i unchecked the fuzzy option it worked for me.