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.
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...
I just ran into the same problem and fixed it by joining the two tables on multiple fields. For example, let's say a transaction number is the unique field you are joining on, expand the join to include other fields if possible. So your joins would be on transaction number, time, and amount.
I changed the privacy settings and still have the issue too. To work around I just used the remove duplicates feature, I know this is not ideal but I know my table only has one line for each record.
I'm facing the same trouble here. Not sure why merging 2 tables create duplicates. Have anyone got a work around this?
Update 9/10 : Problem Solved. My original first table already have got unique rows hence I should have merged it as aggregated values otherwise it will further expand the table, causing duplicates. Also, it helps to use and select more than one field as the key to look up if you need that level of granularity.
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!
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.