Forum Discussion
Model relationships in PowerBI
Hi, I am relatively new to PowerBI (Desktop). As per my understanding the Cardinality between tables in PowerBI can be understood by the line connecting the tables together with the arrow, * and number 1. Arrow indicates the direction, * indicates Many and 1 indicates one; thus if the line arrow is pointing to * from 1, then it is One to Many cardinality (1:*). However, when I double click the line, it shows the relationship as Many to One (*:1). This behavious is reflected when I click any of the lines in the model. Is my understanding incorect? Which is correct? Appreciate inputs. Please see the below picture.
Wheter the cardinality in the dropdown is listed as Many to one (*:1) or One to many (1:*) just has to do with the order they are selected above. If you swap the order the cardinality has to be changed to.
Either way, the relationship looks like this.
2 Replies
Wheter the cardinality in the dropdown is listed as Many to one (*:1) or One to many (1:*) just has to do with the order they are selected above. If you swap the order the cardinality has to be changed to.
Either way, the relationship looks like this.
jdbuchanan71, thanks for the clarification. What you said seems to be correct. However, I have noticed that once you click OK button in the (1:*) relationship, the 2nd picture in your example, and when I reopen it, the notation switches back to (*:1) relationship. It looks like the drop down and the saved relationship default to (*:1) notation.
