Relationship in a visual level

Question

HiWhen I research about relationships between two tables in power bi, people usually explain how to define the join (left, inner etc) in power query. My question is not about that. My question is how power bi defines the type of join that is being done between two tables in the model, when bringing fields from both in the view. For example: suppose I have a table A with 3 ID rows. And a table B also with 3 lines of ID too. In table A I have IDs 1, 2 and 3. In table B I have IDs 1, 2 and 4. That is, I have two lines in common between the tables. When bringing the information from both tables into one visual, what kind of join is Power BI doing? Does it always do an inner join, showing in this case only the two lines in common (ids 1 and 2)? If so, is there a way to redefine this join to, for example, bring all the records from table A and only what has in common from table B?Thanks

gowtham_selvam · Answer

We need to do left outer join for bringing all the records from table A and only the matching ones from table B.&nbsp;If I answered your question,kindly mark it as solution.&nbsp;Thanks,GS

maxbbbfff · Answer

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?

gowtham_selvam · Answer

The default behaviour is left outer join.&nbsp;check out this post :https://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query&nbsp;&nbsp;If I answered your question,kindly mark it as solution.&nbsp;Thanks,GS&nbsp;

maxbbbfff · Answer

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:&nbsp;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.

Forum Discussion

Relationship in a visual level

4 Replies

Related content

Relationship

Matrix Visual Hierarchy Level Problem

Relationships

Relationship Issue

Creating relationships