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 am using Power BI table in my visualization. In this table i drag and drop the columns from two tables which are linked with primary and foreign key.
By default the table is making the inner join and reducing the number of results since some of my primary key table data is not there in foreign key table data.
Now i need to perform the left outer join in my power bi visual table. If the row is not linked the the right side table columns should give me null or zero as value.
Please help
Solved! Go to Solution.
There is a build in option for this in the query editor.
Select the first query you want to join in Query editor, select Merge queries in top right.
Join it on the ID from the second quey and make sure to select the outer join option.
You'll end up with a new (dynamic) table with the result you are looking for. Use this table in your visuals.
There is a build in option for this in the query editor.
Select the first query you want to join in Query editor, select Merge queries in top right.
Join it on the ID from the second quey and make sure to select the outer join option.
You'll end up with a new (dynamic) table with the result you are looking for. Use this table in your visuals.
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 |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |