Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
I have two tables namely Table A and Table B.
When I'm joining the tables in Power Bi it is allowing me to consider only Many to Many relationship.When I create a report on top of these two tables, I'm getting results based on inner join.
I have verified by writing a SQL on backend DB.
My question is in modelling I have created the join like many to many but when creating reports the results are like inner join.
Do anyone faced this type of issue. Curious to know how it is happening.
Thanks,
Anand
Hi @AnandNamburi ,
Can you share some sample data?
Best Regards,
Jay
Hi Amit,
Any inputs from your end, for the above issue.
Thanks,
Anand
@AnandNamburi , what join should be many to many ? Full outer ? It depends.
Hi Amit,
Many to Many is defined in Power BI Modelling and it is Full Outer.
But the results are producing of type inner join.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |