Forum Discussion
Power Query Merge Causing Dropped Rows
I don't know what is causing these but I am doing a merge with Power Query and losing rows when I click on expand. For simplicity sake I have two tables, one has Employee Number and Name and the ...
That's strange. In formula bar your merge step looks like
= Table.NestedJoin(tblNames,{"ID"},tblSalary,{"ID"},"tblSalary",JoinKind.LeftOuter)
?