All language subtitles for 8. Managing & Editing Table Relationships in Power BI Desktop

Let's take a minute and talk about managing and editing relationships because nothing set in stone and

power be-I fact it's very very easy to edit add or delete table relationships.

Now within the relationships view you'll see this manage relationships option that will show you all

of the relationships that exist in your model and give you some tools to add edit or delete them.

Now you can select an individual relationship and hit edit to see some additional details which two

tables are involved which field they're connected by.

In other words which column contains the primary and foreign keys and then also some editing tools that

allow you to activate or deactivate the relationship view the cardinality or modify the cross filter

direction.

So more to come on all of that stuff very very soon.

Now let's up in up RBI and do a very quick basic demo.

All right.

So back in the relationships you we talked about this sales table and the fact that it has to date columns

the order date and the stock date.

And at the moment we can see that the relationships that calendar table is using order date as the foreign

key.

But let's say we want to switch that to stock date instead.

Well from our Home tab click manage relationships we can navigate to that relationship order date to

calendar and we can press at it to see some additional options.

And now it's really just as simple as selecting stock date instead of order date and updating the relationship

that way.

So I can press.

Okay.

Closed the box and now in a hover over that relationship line you can see that stock date field ordered

in that black box.

And now we want to go back and maybe we changed your mind and we actually do want to use order date

instead.

Instead of going up to the menu clicking manage relationships from there I can also simply double click

on that relationship line and jumped straight to the EDID relationship options.

Go ahead and click order date.

Press OK and I'm back where it started.

So again what you're probably starting to realize is that this data modeling this relationship view

is very very user friendly.

In fact you can add and delete relationships in really just a matter of seconds.

For example this customer key relationship to the sales table I could right click delete that relationship

and then simply grab customer key and drag it back to the lookup table and we're back in about five

seconds.

So again power be-I makes it very very easy and user friendly to manage and edit your table relationships.