Forum Discussion

AnandNamburi's avatar
AnandNamburi
Icon for Helper III rankHelper III
4 years ago

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 th...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • AnandNamburi's avatar
    AnandNamburi
    Icon for Helper III rankHelper III
    4 years ago

    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.