Join issue with Power BI

[AnandNamburi]

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

[v-jayw-msft]

Hi @AnandNamburi ,

Can you share some sample data?

Best Regards,

Jay

[AnandNamburi]

Hi Amit,

Any inputs from your end, for the above issue.

Thanks,

Anand

[amitchandak]

@AnandNamburi , what join should be many to many ? Full outer ? It depends.

[AnandNamburi]

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.