Forum Discussion
Relationship in a visual level
We need to do left outer join for bringing all the records from table A and only the matching ones from table B.
If I answered your question,kindly mark it as solution.
Thanks,
GS
The point is: which is the default behavior of power BI? When a get attributes from table A and table B into a visual, he seems to do a Inner Join. How can I change it to a left join, for example?
The default behaviour is left outer join.
check out this post :https://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
If I answered your question,kindly mark it as solution.
Thanks,
GS
This article talk about Power Query. There is possiblie to see the exactly behavior. However, my question is about the default behavior of the join in the design model at power bi desktop:
In this example, when I return the attributes of table A and table B to the view, the view does an inner join. If I bring only attributes from A and values from A or B, the behavior is that of a left join on table A. What I want to know is if the behavior is always like this, that is, it depends on the attributes returned to the visual. And I would like to know if there is a way to change this behavior.