Forum Discussion
Use Left Outer Join in Power BI Visual Table
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 ...
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.