Forum Discussion
Join issue with Power BI
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
4 Replies
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.
Hi Amit,
Any inputs from your end, for the above issue.
Thanks,
Anand
