Looking at Power BI Many to Many

In this video, Patrick takes a look at Power BI Many to Many relationships. This was part of the July 2018 Power BI Desktop release and can enable some awesome capabilities. Patrick looks at why you may not want to use Power BI Many to Many even though you think you do.

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

#powerbi #powerbidesktop #guyinacube

[benschg]

WOW. This was the missing video, I was looking for. I did not know that one could change the direction to both to cross-filter, and this video showed me. I think I am not a total noob to PowerBI, but also, these little things are hard to get in the jungle of options, so anybody pointing me to such tips is highly appreciated. Thankgs Guy in a Cube!

[PaulAeschlimann]

What a great video! Not only have you shown when many to many relationships are most suitable and demonstrated how the same result was achieved before this feature was released, you have also encouraged why it is worth going the extra step to prevent such ambiguities.
A separate video that actually demonstrates such an ambiguity and why it occurs could make it even more obvious, why it is worth going the extra step.

[mundoanaliticooficial]

Great video man. If you do a good job modelling your data, you don't need to use a many to many relationship and only need to use one to many relationship. I never need to use many to many relationship because I spend a lot of time modelling my data.

[di]

I agree, cleaning up the data and reorganizing can have a big impact on performance as an added benefit.

[jarrahalrowayyeh]

Usful and very informative video.
And since am working in the oil & gas company, Many to Many relationship is extremely needed especially if we are working on wells, Reservoirs & fields data..etc for our analysis.

Much thanks

[snehdeep]

High five Patrick! Just the way you explain new functionalities makes life so much simpler! Keep those interesting videos flowing! Thanks :)

[isabelrauch]

Is it logical to merge the 2 tables? I merge almost all of my tables, but I rarely see that as being proposed, I am new to Power BI, so just wondering if I am missing something.

[rodrigomachado]

Many to many shouldn't always be used but it can be extremely helpful when dealing with RLS management acess in my opinion

[diogopinto]

As always, nice, funny and informative video!!! Thank you very much!

[azizquazi]

Can we get the PBIX file to understand how we transformed to Relationship (Final) from where we started? Thanks.

[EyiBillion]

Great video you've got here Patrick.. I have been looking for a way around this many to many relationship issues cos its not always advised to use. I have a project on ground and i am faced with this challenge. I hope this solves it. I shall return with reports.
Once again, Thank you

[farhaadmohsin]

You helped solve a huge problem for me. Thank you very much

[MortenHannibalsenOlsen]

So how do you go about making that nice final dimension table you use in your slicers at the end?

[shresthaupadhyay]

If there are more two keys which are same and unique in two tables which is the most efficient key to join them ? any video to clear my doubts is appreciated thankyou.

[jaclynpugh]

I tried the many-to-many relationship connection between historical orders to a future orders table after the Sept update and my totals again are all wrong... I'm no sure why...

[pedrojimenez]

Thank you Patrick... Your explanations are always on point.!!

[sansden]

Great video as usual ....just wondering how you made the final state metrics table putting both values from those two fact tables in single table.

[zabeepasha]

Hi Patrick, In Power BI we have option to do lookup from vertical to horizontal without transpose the column

[camilogarcia]

Thanks for the video and the tips you give. My question is, How'd you do to get the Final_State_Metrics table? Since both metrics Population and Crimes Per Capita come from two different tables and not necessarily both of them have the same Geography key values

[sahiladya]

how can I maintain hierarchy between multiple role playing dimensions.

for example:

year from one distinct date table is used as slicer and if I select any year then it should filter countries in another slicer coming from another distinct table and selected country should filter relevant states coming from another distinct table.

It is a case where multiple columns like year&country&state are concatenated to create unique key which is joined to another table with similar concat column but this is leading to many to many relationship.

please help