Forum Discussion
Merging 2 tables loses some data
Hi, I have 2 tables, already loaded in PoerBI that I would like to Merge.
I'm using the left Join without Fuzzy merging option and I am basing the Merging on a common column (with even the same header).
The merging works fine for most of the data but does not show the result for some of the lines although I clearly see the values in the second table.
As you see below in the screenshots, for the UNIQUE CLIENT RECEIVABLE Identifier number 614 I see the Payment Amount 1 in the original report but I do not see it in the merged one.
What could be the reason?
Thanks
Merging details
Merged table
Original table
Hi aftorti ,
I cannot reproduce your issue. Could you please peovide more details?
Which join kind you have chosen?
Please check the join kind you wanted.
Merge queries overview - Power Query | Microsoft Docs
If it still does not help, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi aftorti ,
I cannot reproduce your issue. Could you please peovide more details?
Which join kind you have chosen?
Please check the join kind you wanted.
Merge queries overview - Power Query | Microsoft Docs
If it still does not help, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.