Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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.