Forum Discussion
Left Outer Join through Relation ship joining
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