Is MANY TO MANY, too many? | Power BI many to many relationships explained

Подписаться 135 тыс.

Просмотров 44 тыс.

50% 1

In this video we are going to go through Power BI Many to many relationships that were realeased in the POwer BI desktop July 2018 update.
This is what we will cover:
1. What are Many to many relationships
2. Why you should avoid them
3. How to avoid them
Questions, comments? Let me know in the comment box!
Links to related videos:
Composite models: • COMPOSITE MODELS EXPLA...
About Power bI relationships:
Many2many: • Building relationships...
Relationships: • #41 Understanding rela...
Wrong totals:
• DAX Fridays! #25: Wron...
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#SUBSCRIBE #CURBAL
#POWERWEEK #CURBAL #POWERBI #POWERBIUPDATE #MVP

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 106

@juanlopez4033 3 года назад

You know, you are really smart. I appreciate your instructor style. Not that you are trying to avoid M-to-N relationship, but more to understand the way of today's columnar horizontal BI tools behave with data. The essence is most of us are two-dimensional thinkers trying to make sense of cube-dimensional thinking. We can understand 2x2 = 4, but when it comes to understanding 2 to 8th power, we run into possible 256 combinations our mind cannot right away visualize. In database modeling, what you've explained is resolution via Ternary key associating two M-to-N tables, where it is impossible to apply a binary key to the many-to-many relationship tables. Again, thank you for your help. Stay safe. :)

@CurbalEN 3 года назад

And thanks for your explanation and feedback 😊

@joanneosborne2428 4 года назад

Thanks, Ruth. This was very informative and I love the way you explained it. Have a great day and please stay safe and healthy.❤

@VigilanteHD 4 года назад

Much appreciate this!

@sumantjoshi490 2 года назад

I have seen multiple many to many relationship videos on RU-vid but this was the best one. Thanks and Keep up the good work Ruth 👍

@CurbalEN 2 года назад

Thank you!

@ShabnamKhan-vk7fj 4 года назад

Thanks so much for Ruth, you are so kind to share your insights and experience with us. As always, I found it super useful. Please keep up the good work!

@CurbalEN 4 года назад

Yey!! 🎉🎉 /Ruth

@laprasdewgong5022 4 года назад

Great video as always. Easy to understand. Thank you very much Ruth!

@CurbalEN 4 года назад

Yey!! 😃 /Ruth

@Phoenixspin 5 лет назад

I had many relationships many times. My girlfriend didn't like it. Now I just have one relationship with her. Stay away from many-to-many relationships like the plague. Good advice.

@CurbalEN 5 лет назад

😂😂😂 true! Like life itself ! /Ruth

@amantin 5 лет назад

This is a GEM 💎!! Thank you!

@CurbalEN 5 лет назад

Wonderful! And thanks for the feedback ;) /Ruth

@jaimemejia4387 4 года назад

Gran explicación, muchas gracias. Tus videos han sido de gran ayuda para aprender Power Bi, Dax y el modelado de datos.

@CurbalEN 4 года назад

Un placer! /Ruth

@maheshpulli1663 4 года назад

Thank you very much.

@toygraphers240 2 года назад

Thank you very much

@SpacePoodle 5 лет назад

Great vid!! Thanks for sharing your skills :)

@CurbalEN 5 лет назад

And thanks to you for watching!! :) /Ruth

@indunildayawansa5087 4 года назад

Hi Ruth, if I have same values in multiple columns how do I make a relationship? Table has Employee number, Equip1, Equip2, Equip3, Equip4 upto 10 items and their model, Serial etc. Equip1 have computer, Laptop, Monitor, Keyboard etc. and same data in Equip 2, 3, 4. So if I want to know how many laptops, desktops etc for each employee, how do I make relationship?

@indrewhite 3 года назад

Love your channel and advice on power BI!

@CurbalEN 3 года назад

Thanks Indre!

@tanababa 6 лет назад

Thank you Ruth, great video

@CurbalEN 6 лет назад

Phew! Glad it was useful ! :) /Ruth

@kristinamelnichenko5775 3 года назад

Very good thank you

@pulkitverma1105 3 года назад

Great Video. Thanks

@luisjavier1284 5 лет назад

I really impressive. I like the way that you usted to explanó the things. You clarified me how relationships work. Thanks you. I subscribed to to your Channel

@CurbalEN 5 лет назад

Welcome to the channel y Saludos! :) /Ruth

@juja2819 6 месяцев назад

Thank you for the explanation! Would like to see a measure multiplying two columns from each table in examples with bridge tables, for instance at 11:13, Amount and StockNo. Is this possible?

@xiomaragotch9453 3 года назад

this solved the issue that I was experiencing. Thanks so much!!!!!!!!!!!!!!

@CurbalEN 3 года назад

Delighted to hear that!

@Nicky411 5 лет назад

Thank you sooooooo much! I'm used to Informatica, and it is really hard to get used to PowerBI.

@CurbalEN 5 лет назад

Push through! The rewards are behind the corner ;) /Ruth

@lisbongraffiti242 11 месяцев назад

When you add this kind of tables for a many-many relationships it can be considered a star model or is a different kind?Thank you

@angelobarroso5912 2 года назад

I just find your youtube videos. I think you´re great. Awesome explanations. I've subscribed your channel. Keep going. congratulations!

@CurbalEN 2 года назад

Welcome!! ;)

@EyiBillion Год назад

Brilliant! Great Job. This solved a puzzle struggling with for a long time.

@CurbalEN Год назад

Music to my ears!!! 😃

@jasonwoodward5501 4 года назад

Happy Christmas and thanks again

@CurbalEN 4 года назад

Merry Xmas!! /Ruth

@Lena2012102 5 лет назад

Great video! It will be nice to hear also, how to prepare formulas for BASKET analysis. If you need to understand how many and wich products were bought, when one specific purchased.

@CurbalEN 5 лет назад

Oh yes! I did that for a customer a while ago, I can prepare a video in the future. /Ruth

@jasonwoodward5501 4 года назад

Thanks Ruth

@jaguarprovo 2 года назад

Ruth you’re a life saver.

@CurbalEN 2 года назад

Thank you!

@kebincui 3 года назад

Thank you Ruth👍

@CurbalEN 3 года назад

My pleasure!

@nikhilagarwal9689 2 года назад

Great video..helped me to resolve the issue. Thanks for sharing 😊

@CurbalEN 2 года назад

My pleasure!

@tabish.k.ansari 4 года назад

Thanks

@fsdanything9116 5 лет назад

Hi - I know this is only partly related, but have you found a way of managing the tables in the relationship view so that they stay where you put them ? I have re-arranged my tables sooo many times now

@CurbalEN 5 лет назад

You mean the relationships or the actual tables? /Ruth

@edsta714 6 лет назад

Sometimes I have a lot of columns that would require over 20 bridge tables for example. I’ve gotten around it by making a concatenated column to make it unique 1 to 1. Just wondering if you recommend any other methods? Thank you. Your videos are always educational.

@CurbalEN 6 лет назад

Creating unique keys is a great way to get around the problem. Depending on the model, I would probably do the same :) /Ruth

@eladiobardelli3001 6 лет назад

Ruth podrías hacer un día de estos , un vídeo sobre el proyecto que mas te ha gustado de Power Bi que hayas efectuado y explicando detalles hechos y retos que tuviste en el camino desde el punto de vista objetivos y desafíos Dax.

@CurbalEN 6 лет назад

Los proyectos en los que trabajo son confidenciales, tendría que preguntar a mis clientes. Has visto los vídeos de la FIFA? Los hice en vivo y en directo casi... /Ruth

@thihaihahoang4609 4 года назад

Great vid! Tks so much for sharing this. However after registered for member, I was trying to join the community and download sources but I couldn't. How can I contact for help please? Much appreciated! 🙂

@CurbalEN 4 года назад

Send me an email here: Curbal.com/contact And I will get back to you tomorrow. /Ruth

@MohammedAliOmairi Год назад

thanks

@Wzxxx Год назад

But why it should consider ie. product filter when being connected by date ? What do You mean by ignoring? If it was "normal" relation it would be the same. You do not use any filter on dates (in both tables at the same time tables as there is no date table which connects both)

@frankgovers8420 6 лет назад

Great Ruth, but what if there are products in the budget table and not in sales. Now the product filter does not work. So filtertable product must have values from both tables, without duplicates

@CurbalEN 6 лет назад

I didn’t mean that this is the master way to solve this, I just pointed it as one solution, hope that was clear! That is the trickiest thing about DAX, no formula or model fits all! The point of the video is explaining the many to many relationships:) /Ruth

@frankgovers8420 6 лет назад

Curbal youre right, but I am always analysing the problems

@CurbalEN 6 лет назад

No worries, you are right too ;) /Ruth

@marwatkinson 5 лет назад

Hi in your solution, did you put the table like in 6:31" ? Because I can't really see how that will be solved

@CurbalEN 5 лет назад

Not sure what you mean with "put the table" /Ruth

@sandipansarkar9211 8 месяцев назад

FINISHED WATCHING

@CurbalEN 7 месяцев назад

👏

@neelamzaidi1683 2 года назад

I LOVE YOU!!!!

@josepromero1452 6 лет назад

Exact! Ruth. The best advise is: DO NOT USE M2M RELATIONSHIPS and use traditional method. I tried (as you) when it was released and immediately forgot it. Really good and practise video! Josep.

@CurbalEN 6 лет назад

Thanks!! Those that are more familiar with M2M can probably use it , but for the rest of us mortals... best to stay away! /Ruth

@Ahmad_Askar 6 лет назад

can i ask which whiteboard tool you are using? great video by the way i am always a fan of a bridge table

@CurbalEN 6 лет назад

Hi! Epic Pen, great tool and Thanks! /Ruth

@Ahmad_Askar 6 лет назад

Thanks a ton

@user-gy7uu9gt8n 2 года назад

Why the relationship direction is single for calendar and product at the end not both? Or it doesn't matter.

@user-gy7uu9gt8n 2 года назад

Oh it will cause a cycle!

@xuantungnguyen9719 3 года назад

the food example seems like a one:one relationship with composite key is date+food_name. Feel free to correct me if I'm wrong.

@nguyendaominh1078 2 года назад

There are duplicates in both "Date" & "Product name" in both tables, so how come it's a one:one relationship?

@ahmedal-dossary4386 5 лет назад

Impressive ✋🏻

@CurbalEN 5 лет назад

Yey! 🎉 /Ruth

@srinivaskandru5034 5 лет назад

Everything is awesome...but please change the image after 0:55 for subscription call...it is not good..heheehhe. You are looking good in that image..it is lifeless...But definitely I got the point you explained in this video.

@CurbalEN 5 лет назад

Hahahaha it is meant to be “bad” , but I didn’t know it was that disturbing! I will change it as soon as I can! /Ruth

@srinivaskandru5034 5 лет назад

Frankly speaking, it reminds me a cancer patient who has just returned from hospital after a chemotherapy treatment..loosing all the hair over head...sorry....pleeeease change it immediately....

@CurbalEN 5 лет назад

😂😂 is not that bad!! /Ruth

@DanielWeikert 5 лет назад

Most of the time I hear many to many is dangerous because of potential ambiguity in the model. Could you elaborate on different scenarios when they really make sense? Thank you. Great video

@CurbalEN 5 лет назад

Sqlbi has a few, check them out if this one didn’t help. /Ruth

@DanielWeikert 5 лет назад

@@CurbalEN Thanks Ruth, yes I already checked them but still looking for more. It's a quite interesting topic. Best regards

@CurbalEN 5 лет назад

I agree! As I stay away from M2M I don’t have good cases to showcase. Have you tried asking in the power bi community? /Ruth

@DanielWeikert 5 лет назад

@@CurbalEN good idea. Just prefer video over description. ;) Visual learner