Use Left Outer Join in Power BI Visual Table

[Anonymous]

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

[Anonymous · Accepted 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.