How to create left outer join the power bi

[afleiderman1]

I have these tables in my model and they are connected by a left outer join in tableau

and I am wondering how to do this in the power bi. 

I got two table in tableau that are linked ot a third by left join.

I am wondering how can I do the same in the power bi

I tried doing relationship

Is there anyway to left join from power bi relationship kind of like in tableau. 

[ZDBobbitt]

This tutorial provides a step-by-step example of how to perform a left outer join between two tables: https://www.statology.org/power-bi-left-join/

[Anonymous]

New poster here. 

In my Power BI Desktop, I do not see Merge Queries option in the Home ribbon. All I see is Get data, etc, Transform data, Refresh, New measure, More visuals, Publish. I do not see the Combine or Merge Queries options under Report, Data or Model. Is there something I need to activate through the main Options menu under File? I am using version 2.108.997.0 64-bit (August 2022). Thanks!

[kylesmyle]

Click 'Transform data' first

[ribisht17 · Accepted solution]

@afleiderman1 

Please find the step by step instructions here 

Merge queries overview - Power Query | Microsoft Learn

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[Migasuke]

Hi @afleiderman1 ,

Question is, what are you trying to achieve? But generally speaking you have 2 options. Use relationships or use Power Query.
In Power Query you have exactly the same logic of LEFT / RIGHT JOIN. Just a note, in Power Query the operation you search is called "Merge" (Join).