Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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/
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!
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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
67 |