Understanding Relationships in Power BI // Beginners Guide to Power BI in 2021

[@donharrold1375]

Excellent - best explanation I've seen explaining why issues with table relationships occur and how to resolve them. Many thanks!

[@w2w112]

Wow.. I now understand relationship

[@SolutionsAbroad]

Good to hear!

[@alanrowe7010]

What are the different tabs for in the relationships screen?

[@Glaszg]

I like this video but in real world there are live connections to database and the relationships work quite different for live connections. Id be great to see a video on that too

[@veebee3969]

Thank you. Very helpful video.

[@ddphotograph]

Thank you, you made it easy for me to understand

[@SolutionsAbroad]

You are welcome, thanks for watching!

[@Sandroider]

Can you show some example about possible issues/problems when both directional is selected, what could happen?

[@SolutionsAbroad]

Hey there, it introduces ambiguity to the direction of your filters, I dont think I've covered an example but here's a good article explaining this with an example: www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

[@robertoserrano48]

I want to aply some DAX formulas two betwen the relation tables is that possible?

[@SolutionsAbroad]

I don't see why not, just bear in mind how the relationships work and how the filter flows from one to another

[@就已]

Good job my man

[@SolutionsAbroad]

Thank you! 😃

[@erinfield1943]

5:10- the point of inactive relationships

[@lovlyhearts288]

I enjoyed this video. Post more complex modelling and how the flow happens.

[@raviranjansingh5527]

Thanks sir , cover of great topic,

[@SolutionsAbroad]

Thanks for watching!

[@AlbrechtJ]

Thanks for this helpful video.

[@cibisarancb]

Short and sweet

[@abdul8236]

Thank you

[@SolutionsAbroad]

You're welcome

[@nishikantanayak7797]

someone explain my doubt Product ID relationship between Products table and Order deatails table should be 1 to 1 And not 1 to many someone explain

[@AliAhmed-ko5nl]

great work keep it up !

[@SolutionsAbroad]

Thanks, will do!

[@rajeshpoluru8120]

Can you please provide the link for Northwind database and login details please

[@SolutionsAbroad]

Hi Rajesh, the Northwind db is something installed on my local machine, so you wont be able to connect to it. You'll need to install it on yours, here's the GitHub link to it: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

[@rajeshpoluru8120]

thanks Fernan I will check

[@akashkumar-bq7cl]

thanks alot :)

[@SolutionsAbroad]

You're welcome!