Forum Discussion
Left Outer Join through Relation ship joining
Hi Team,
Problem : I want to create left outer join with relationship mapping instead of SQL Queries
Steps :
Step1 : When I go to manage relation, select the 2 tables with their primary id joins and then click on relation many to one and cardinality as both a relation ship is created.
Step2 : When creating Report I can get attributes from both the tables
Step3 : Problem here is the after extracting meaning exporting I am not getting the exact count.
Step4 : After some analysis I see that if any attributes are having null values power bi delete that particular rows.
Please help us for the solution .
Anonymous
This relationship is not something like join in SQL, manage relationship is about filer directions. You may use Power Query instead of relationship and sql query, merge query is your best option.Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous
This relationship is not something like join in SQL, manage relationship is about filer directions. You may use Power Query instead of relationship and sql query, merge query is your best option.Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.create a index column for the table with null values for the specific column and check that columns filters steps to avoid it from filtering out null values,
the index column will make all existing row have a value to work as reference for that exact row,
also check why its generating null value if its a key column, it shouldnt have null values
