Forum Discussion
How to create left outer join the power bi
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.
Anonymous
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
5 Replies
Anonymous
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 SeriesHi Anonymous ,
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).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!
Click 'Transform data' first
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/
