cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Metadata text view on Table relationships in Power BI

I know you have the diagrammatic view of relationships in power bi, but is there a quick way to see like in a table format to see what tables are mapped to where and on which key?  The reason i ask is because i have a HUGE model with 30+ tables and its really annoying to have to go and click on each relationship to see what its mapped to - is there another way of pulling those relationships where i can see them all in a textual manner?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
1 ACCEPTED SOLUTION

Accepted Solutions
norahfox Frequent Visitor
Frequent Visitor

Re: Metadata text view on Table relationships in Power BI

Have you tried hitting "Manage Relationships" in the Modeling tab on the ribbon?

6 REPLIES 6
Super User
Super User

Re: Metadata text view on Table relationships in Power BI

It's an interesting question. I teach Power Pivot and I sometimes get asked similar questions. I always tell people that they don't need to know. Tables either have a relationship or they don't. If they do, then they are related - that's it. It should be irrelevant which columns are used for the relationship (assuming it was done correctly). So certainly if a model is not working, then there is a need to check the relationship to see if a mistake has been made. But if it is working, then it's working, and there is no need to know which is the keyed columns. 

 

Thats my view anyway. 

 

Power pivot utilities for Excel can extract info like this from a power pivot model, but it doesn't work for Power BI. I am sure ther meta data is there in a DMV somewhere but I don't know which one. 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User
Super User

Re: Metadata text view on Table relationships in Power BI

if only it was that simple Matt!  Smiley Happy

 

Im in the stages of mapping all the relationships i need for my model, i just want to make sure i haven't missed any and also ensure ive done it on the right key, so it is actually required from a point of due dilligence.

 

The other way to find out is when things dont work.    Not the ideal.

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: Metadata text view on Table relationships in Power BI

How many relationships do you have?

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
norahfox Frequent Visitor
Frequent Visitor

Re: Metadata text view on Table relationships in Power BI

Have you tried hitting "Manage Relationships" in the Modeling tab on the ribbon?

Super User
Super User

Re: Metadata text view on Table relationships in Power BI

well i have 2 fact tables and minimum 30 dimensions linking to them


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: Metadata text view on Table relationships in Power BI

its not on the modelling ribbon is on the home ribbon but that works thank you!


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!