Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
In power bi, which join consider for cardinalities?
cardinality joins(inner join, left join, right join)
one to many ?
many to one ?
many to many ?
please assist.
Thanks
Kunuthuri
Can you please share more details of your question?
Thanks
Raj
Hi Raj,
Thanks to reply,
Below cardinalities, when compare with joins one to many means right join like that are any difference.
cardinality joins(inner join, left join, right join)
one to many - Right Join
many to one - Left Join
one to one - inner Join
Thanks
Kunuthuri
HI @Anonymous,
In actual, power bi not contain for join modes which you mention.
Current power bi will try to use inner join mode to analyse relationship and records, through relationship mapping. So it only allow one active relationship between two tables.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |