SOLVED

Power Query help

%3CLINGO-SUB%20id%3D%22lingo-sub-1497557%22%20slang%3D%22en-US%22%3EPower%20Query%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22prueba%20del%20modelo%20anterior%20power%20query.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202944i91AB4B9E1F2A85BE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22prueba%20del%20modelo%20anterior%20power%20query.png%22%20alt%3D%22I%20need%20this%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EI%20need%20this%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mal.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202945i4A6583A942354150%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22mal.png%22%20alt%3D%22this%20is%20wrong%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Ethis%20is%20wrong%3C%2FSPAN%3E%3C%2FSPAN%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20some%20time%20ago%2C%20I%20got%20knowledge%20about%20a%20extremely%20good%20option%20of%20power%20query%2C%20%22outer%20join%22%2C%20but%20I%20don't%20know%20why%20with%20my%20father%20laptop%20and%20with%20my%20personal%20computer%20I%20don't%20have%20this%20option%2C%20I%20was%20thinking%20about%20maybe%20my%20father%20has%20a%20cheap%20version%20of%20office%2C%20but%20my%20excel%20is%20the%20best%20version%20of%20Excel%202016%2C%20the%20Professional%20Plus%20version%2C%20and%20when%20I%20try%20to%20merge%20a%20query%2C%20it%20just%20says%20%22only%20include%20matching%20rows%22%20like%20a%20check%20option%20and%20I%20remember%20with%20my%20job%20laptop%2C%20I%20was%20using%20options%20like%20%22outer%20join%22%20and%20there%20are%20another%20options%20with%20a%20part%20named%20%22join%20kind%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20to%20get%20that%20option%20outer%20join%20available%3F%20I%20really%20can't%20understand%20how%20it%20isn't%20available%20since%20I%20have%20the%20professional%20plus%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efull%20outer%20join%20is%20the%20same%20thing%20that%26nbsp%3B%3CSPAN%3E%22outer%20join%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20extra%20information%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1503414%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713909%22%20target%3D%22_blank%22%3E%40alemicrosoft%3C%2FA%3E%26nbsp%3Bwell%2C%20here%20I%20don't%20have%20answers%2C%20but%20by%20a%20real%20time%20chat%20support%20from%20Microsoft%20I%20got%20a%20solution%2C%20a%20full%20update%202020%20of%20this%20office%202016%2C%20and%20my%20power%20query%20is%20now%20working%20well%2C%20giving%20it%20a%20solution%20to%20this%20problem%20still%20with%20office%202016%20(I%20don't%20like%20for%20now%20the%202019%20version%2C%20thanks%20for%20the%20support%20team%20I%20have%20now%20the%202016%20version%20working%20well)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need thisI need thisthis is wrongthis is wrongHello

 

Since some time ago, I got knowledge about a extremely good option of power query, "outer join", but I don't know why with my father laptop and with my personal computer I don't have this option, I was thinking about maybe my father has a cheap version of office, but my excel is the best version of Excel 2016, the Professional Plus version, and when I try to merge a query, it just says "only include matching rows" like a check option and I remember with my job laptop, I was using options like "outer join" and there are another options with a part named "join kind".

 

Can you help me to get that option outer join available? I really can't understand how it isn't available since I have the professional plus version.

 

full outer join is the same thing that "outer join"

 

Just extra information

1 Reply
Highlighted
Best Response confirmed by alemicrosoft (New Contributor)
Solution

@alemicrosoft well, here I don't have answers, but by a real time chat support from Microsoft I got a solution, a full update 2020 of this office 2016, and my power query is now working well, giving it a solution to this problem still with office 2016 (I don't like for now the 2019 version, thanks for the support team I have now the 2016 version working well)