Skip to main content

Power BI

Needs Votes

FULL OUTER JOIN and LEFT JOIN from One to Many

Vote (3) Share
John Altamura's profile image

John Altamura on 14 Dec 2018 22:18:38

I would like to have the ability to return all rows from both tables in Power BI, when fields from both tables are present in the same visualisation, and there is nothing to join on in the relationship column. This would be equivalent to a SQL FULL OUTER JOIN.

I would also like the ability to return all rows from the "One" side of a One:Many relationship, when fields from both tables are included in the same visualisation. This would be the equivalent of a SQL LEFT JOIN where the table on the "One" side of the relationship is on the left. Currently the default join for a One:Many relationship in Power BI is effectively a LEFT JOIN with the table on the "Many" side of the relationship on the left.

Comments (1)
John Altamura's profile image Profile Picture

John Altamura on 05 Jul 2020 23:37:23

RE: FULL OUTER JOIN and LEFT JOIN from One to Many

When I posted this, I had in mind using DAX to join! - I know this can be done already in M.