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 thir...
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
Migasuke
Memorable Member
Memorable MemberHi 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).