Leftouter join

[Anonymous]

Hi All, I have a senerio where my model requirement is to pull all outer joins as of now in power bi we dont have direct gui to change releation like tableau and i had done with merge as new option and given the releation ship. now im experiencing an performance issue like slow in opening model and do any edit option in manage releationship. Can any one suggest better solution that merge can i try with dax naturallleft join function.

Thank you,

nag

[v-piga-msft]

Hi @Anonymous，

There is no naturallleft join function in Power BI, only NATURALINNERJOIN Function and NATURALLEFTOUTERJOIN Function.

I'm a little confused about your scenario, could you describe in more details and if it is convenient, could you share your data model structure which can reproduce the scenario and your expected output, so that we can help further investigate on it? 

Besides, you could have a reference of the similar threads below.

Merging table with a left outer join

https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/td-p/218906

Best Regards，

Cherry

[Anonymous]

Hi Cherry,

In power bi we cant find which joins it creats initially if we want to do merging it hepls in selecting joins.

my question is by deafault which join is been appiled in model.

Thank you

[Anonymous]

TQ cherry!

As discussed above the senerio is i hv tables like Schedule F,Schdule_D,Prod,date,geo.

So my requirement is to join all tables to fact using left outer join i already merge as new and created leftouter join.

My concern is about the performance since we merged so do we hav any better solution

Thankyou

[Stachu]

do you want to have separate tables and keep joins between them in DAX model, or do you want to merge them all in one big table using outer join and load that to the model? I'm not clear what is the requirement here.

[Anonymous]

Both are fine

we can merge all in single table with leftouter join but the problem for prod table i dont have direct releation ship to merge in fact table.

so thats y i gone with merge as new option 

thank you

[Stachu]

creating flat table will most likely not help performance, but should give you the result you need
you can do it based on the @v-piga-msft link 

Merging table with a left outer join
potentially you can also use virtual relationships directly in measures 

[Anonymous]

Here is the detailed view wha t i have done

1st merge-sch_f&sch_D-New merge sch_F

2nd merge -New merge sch_F&date-merge Date

3rd -we we dont have direct releation ship for prod_D so i merged course_&Prod_D 1st and final merge with New merge sch_F

4th-New merge sch_F-Venfor_d-Merge_Vendor