Forum Discussion
Outer Left Join Power Query not returning joined matches
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi,
Thaks for your answer. You can find the file here https://docs.google.com/spreadsheets/d/1IbweWkfPkAXU3yt-CJMu4vEA19vZXXME/edit?usp=sharing&ouid=104612261627157802886&rtpof=true&sd=true
Please go to PowerQuery Table 'StockReposicion'. You will find the error in the last 2 steps. First the join and then when is expanded. What its seen inside the joined column that contains a table it looks fine. Then when expanded results are different.
Thanks for your help.
I hope someone comes up with an explanation.
It doesn't seem to matter what kind of Join you specify; they all seem to work OK with regard to the resultant table, but then provide the incorrect results for both tables when you expand them.
Of interest is that if you do a Table.Join (not nested), the result is what it should be. So the following modification would work:
... #"Consultas combinadas1" = Table.Join(#"Filas filtradas3", {"Ubicacion"}, Layout, {"Descripción"}, JoinKind.LeftOuter), #"Removed Columns" = Table.RemoveColumns(#"Consultas combinadas1",{"Descripción", "Sector", "Nivel"}) in #"Removed Columns"producing:
