Forum Discussion
Table Merge creates duplicate records
The problem lay with the Data.
The LEFT JOIN functionality of PowerBI works perfectly.
The problem lay with the Data.
The LEFT JOIN functionality of PowerBI works perfectly.
I'm having the same issue thanks. What did you do to fix your data set?
Hi, I was having the same issue, and then I noticed that my second file, from where I was getting the data, had also duplicated figures. That was the problem. After I deleted those duplicates, I clicked on the refresh button, and the problem was solved!
So, I am having the same issue and I just found your post and read it with hope. Although it has been helpful my issue is a little different just a tiny bit.
What I am doing is mergint two tables I am creating with M inside the advance query for one of my tables. In this operation I create two tables by doing a left anti join, that works fine.
I have table A that are all new leases.
I have table B with all terminated leases.
I want a single table C with both, so I need two columns, new lease, terminated lease. All this is fine so far.
I do then a nested join which is a left outer from the new leases to the terminated leases, so im keeping all that is new and just putting a false in those that are not.
The moment i merge is ok, but then when i expand the table is when booom, i get duplicates. The problem i just found is that while im using lease_id as my key to join, there are some that do not have that key because they are not leases, they are owned so it is a different number, and coincidentally those are the duplicated ones.
Any ideas on how to solve it ???
- Hi I’m having the exact same issue when merging two tables, I see you posted that the issue lays with the data and not the merge, can I ask how you solved it? I’m pretty sure I have unique values so I believe that is not the issue, actually the merge is working on someone else’s computer but not on mine. Appreciate any hint you may provide.
Sadly, I still have not been able to fix this problem with the "Merge" feature. I have resorted to using "Append" instead - and in some cases it works and in others it doesn't. It is a very frustrating situation.
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.
Hi, you may try to match more than one field to obtain a unique set of data match.
