How to Create RELATIONSHIPS in Power BI

[@geeves21312]

Excellent clarity. Really like your structure.

[@NestorAdrianzen]

Glad you found it helpful! Keep up the good work, GB! 👊

[@Jashi_Kholin]

I love your use of illustrations. It really helped me understand cardinality.

[@NestorAdrianzen]

Excellent! Keep it up, Shan!

[@ramnathrajagopalan0510]

Thank you so much for a quick brief. I now have full understanding of the relationship in power bi.

[@NestorAdrianzen]

Glad to hear that. Cheers👍

[@ridwanrajabally9778]

Just perfect. Thnx for this tutotial

[@NestorAdrianzen]

Glad it was helpful. Cheers!

[@dineshkumar-xg5ub]

Thanks very much for making such a useful video.

[@NestorAdrianzen]

Glad it was helpful! Keep up the great work, Dinesh!

[@mchandrasekhar05]

Worthy video for better understanding relationship in power bi

[@NestorAdrianzen]

Glad you found the content helpful. Keep it up, M Chandrasekhar!

[@ravikumar-rw5rm]

Your teaching style very nice Sir

[@NestorAdrianzen]

Glad it helped! Keep up the good work, Ravi.

[@AlbrechtJ]

Good tutorial. Thanks.

[@NestorAdrianzen]

Thanks for your support, Kahn!

[@jonasyung5698]

This video is super cool and clear, thanks for sharing!

[@NestorAdrianzen]

Glad it helped. Keep up the good work, Jonas!👍

[@NestorAdrianzen]

Hey guys, Question. What part of this tutorial has helped you the most? Please let me know by leaving a comment below. Cheers!

[@jasminecoleman5692]

It was helpful that you broke it down like a tree structure. For example, you said there are 3 types of cardinalities, and with Many-to-Many, there are 2 ways to implement it. Thank you for your clarity!

[@NestorAdrianzen]

Thanks, Jasmine! Glad you found this tutorial helpful. Please stay tuned for more PowerBI lessons.

[@danielpalacios9085]

So simple, so digestable. Thanks a lot!

[@NestorAdrianzen]

Glad it was helpful! Keep it up, Daniel👍

[@chinosantillan3840]

Gracias Ernesto muy muy útil- muchas gracias

[@NestorAdrianzen]

Excelente, Chino Santillan! Gracias por el feedback. Recuerda que este es un canal bilingüe y también puedes encontrar las versiones en español. Saludos! kzbin.info/www/bejne/r5rFdWZ6gp5mf9U

[@rameshkomarapuri9036]

crystal clear explanation. Thanks

[@NestorAdrianzen]

Glad it was helpful!

[@midsummer4864]

Nice presentation. You speak in a manner that is easy to understand. Thank you Sir

[@NestorAdrianzen]

Thanks, Midsummer. Please stay tuned for more lessons!

[@bharathreddy4267]

Great explanation, tnq

[@NestorAdrianzen]

Glad it was helpful! Keep it up, Bharath.👍

[@yvrao1138]

Boom that's awesome. Thank you

[@NestorAdrianzen]

You bet💥

[@kalyanperla9767]

Thank you , cleared the concepts 😋

[@NestorAdrianzen]

Kalyan Perla, glad you enjoyed the content. Keep up the good work!👍

[@knowledgeinsights_rosal1185]

Please answer how do the delivery time dates changed?@11.53 Iam not getting after relationship is established.

[@NestorAdrianzen]

Rosal Channel, thanks for your question. The delivery time values change right after the relationship is created. If this is not working, you might want to double-check the following: 1) Key/Common column between ClaimsU and Channel should be "customer" 2) The data type for the key/column should be the same for both tables (data type: text) 3) Cardinality should be one-to-many (1 : *). One (1) for ClaimsU and Many (*) for Channel 4) Cross filter direction should be "Single" 5) In the table in the report, "Customer" should come from the table with unique values (ClaimsU table)

[@chandrikasingh9322]

The best tutorial i can say regarding modelling in power bi.. thank soo much.. can u pls tell me where can i get those tables????

[@NestorAdrianzen]

Chandrika, Thanks for your feedback. I usually share the content links in the video description. Here it is: drive.google.com/file/d/1LzTtZs1VpdUgMFO2ENppwt00jx0qDKng/view?usp=sharing

[@JWB1081]

Thank you Nestor, this was tremendously helpful!

[@NestorAdrianzen]

Glad it was helpful!

[@islam48ify]

What if we have for exemple more than two table and the table 1 is related to table 2 and table 2 is related tp table 3 My question is Is the filter will work between table 1 and 3 or no?

[@NestorAdrianzen]

Mohand, That's a good question. Yes, according to your example that's possible. When you apply any filters, make sure to select the common column with unique values. Keep up the good work!

[@shreyjain6447]

Hey great video! I have 3 tables and all 3 contain zip codes. Even after appending queries as new and removing duplicates I still get the message that the relationship is many to many. Even after removing duplicates why does it give the same message?

[@NestorAdrianzen]

That's interesting! Make sure that the new relationship is between the new table (the one that was just created) and the fact table in the model. Also, double check that the headers are the same for the 3 tables that you are appending. If the headers spelled differently, you will have different results. I hope that helps!

[@baleani1955]

Once again thanks for the video and your response, however, the absence of EDIT QUERIES button is causing a lot of confusion, some argued that if all data is transformed there will be little or no need for the edit queries. Two things are not clear i. is the button hidden with another name ?. ii. Will transform data help when one need to append or merge. Many new and old users are raising this on different forums.

[@NestorAdrianzen]

Bale, Thanks for stopping by. I think you are referring to the "Transform Data" feature within Power BI Desktop. In this tutorial, I'm creating a calendar table with DAX, so, we won't have access to edit this table with Power Query that uses the M language. The reason for this is that DAX and M are two different languages and are not integrated as far as I know. If you'd like to edit your calendar table within Power Query, you will need to create a calendar table with Power Query by using the M language. This tutorial will help: kzbin.info/www/bejne/nZmXh52MoqqVmK8

[@islam48ify]

Thank you

[@NestorAdrianzen]

Mohand, Glad you are enjoying the tutorials!

[@garrybissell1891]

Excellent, you explained this very well. It is part of the foundation and building block of building a report, if this part is incorrect, the rest can fall down, often with inaccuracies not picked up until much later, and these can be costly when relying on BI. 😉✔

[@NestorAdrianzen]

Garry, glad to hear this. Keep up the great work!👍

[@majidelmajidi386]

Thanks a lot, it helps me to solve my current problem

[@NestorAdrianzen]

Glad it helped! Keep up the great work, Moch!

[@sravankumar1767]

Very nice 👌

[@NestorAdrianzen]

Great!

[@bearwithnawreenpriya8508]

there is no manage relationship option in my Power Bi

[@NestorAdrianzen]

Nawreen Priya, Thanks for stopping. Make sure to select the "Model" option first (top left corner of your canvas) and then, the "manage relationship" option should be visible in the ribbon. I hope that helps. Cheers!

[@bearwithnawreenpriya8508]

@@NestorAdrianzen thank u. Will try

[@hermerbalan82]

Thanks Nestor

[@NestorAdrianzen]

Any time. Keep up the good work, Hermer.

[@baleani1955]

Fantastic

[@NestorAdrianzen]

Thank you! Cheers!

[@mnesevati]

Thanks for this, you're great...I have one question: why when we load the table into Power BI, a number are being added next to the table name, Like Channel1, CliamM2...etc

[@NestorAdrianzen]

Muhammed, Thanks for stopping by. This might be happening because Power BI is recognizing the table twice and by default a number is being added to the original table name. To solve it, you might want to rename the table in Excel (before uploading it to PBI) or in Power BI itself. I hope it helps. Cheers!

[@mnesevati]

@@NestorAdrianzen well noted thanks, Actually I have been watching your lesson a week ago, they are explained very well and usefull.

[@NestorAdrianzen]

Excellent! Keep up the good work.

[@sravankumar1767]

I have one doubt can you explain it briefly this question was asked in interview: 1) why should we use one to many relationship give some examples and explain 2) If we take many to many Relationship In power bi what would happen , y Don't We concern many to many give me some examples Please share i couldn't answers these questions

[@NestorAdrianzen]

1) In a one-to-many relationship, you can just connect one item from a table to many items from another table. This approach is helpful because we can be 100% sure that just one item is connecting to the other table's items. When you are filtering data, the column from the one side table should be selected. 2) In a many-to-many relationship there is ambiguity and the outcome might not be the expected one.

[@sravankumar1767]

@@NestorAdrianzen Excellent ,Thanks for your cooperation Nestor..

[@anjaneyulugodduvelagala]

please provide the source data

[@NestorAdrianzen]

Anjinavya Rocks, Thanks for stopping by. I usually share the content links in the video descriptions. Here is the link for reference:drive.google.com/file/d/1LzTtZs1VpdUgMFO2ENppwt00jx0qDKng/view

[@harshalexcelbi2314]

Boom

[@NestorAdrianzen]

Awesome! Boom💥

[@sonetmollick4630]

Good explanation. But it was a bit annoying when you make sound suddenly with loud voice.

[@NestorAdrianzen]

Sonet, Glad you found the content helpful. Thanks for the feedback as well.