Forum Discussion
Relationship in a visual level
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.