cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rps_ken_yu Frequent Visitor
Frequent Visitor

Dates Table Relationship to show just primary or secondary key

I have bunch of tables with LOTs of columns and so on the relationship view is hard to view.  Is there a way to just show the primary and foreign key?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dates Table Relationship to show just primary or secondary key

@rps_ken_yu,

 

Based on your description, your requirement is to hide the columns except primary key and secondary key, right? Click File-> Options-> Modeling view, after restart power bi, you will see the data model view option on the left pane, then click the shift and the columns you want to hiden, enable Is_hidden option like below:

Capture.PNG 111.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 REPLIES 5
Super User
Super User

Re: Dates Table Relationship to show just primary or secondary key

Modeling tab | Manage Relationships


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


rps_ken_yu Frequent Visitor
Frequent Visitor

Re: Dates Table Relationship to show just primary or secondary key

@Greg_Deckler that helps.  It seems to be able to add and remove relationship between tables.  However, if I have some fields that I do not need to show on this, for example, lets say that I have an invoice header and invoice detail table.  I want to see invoice primary key but not the line item totals and tax in the relationship diagram but would like to query it and so would like it to be listed when I go to the visualization tab.

 

Thoughts?

 

Super User
Super User

Re: Dates Table Relationship to show just primary or secondary key

Not following. All available tables and columns are listed in the FIELDS area. Are you saying that you are looking for some sort of context awareness?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


rps_ken_yu Frequent Visitor
Frequent Visitor

Re: Dates Table Relationship to show just primary or secondary key

In an attempt to clarify based on InvoiceHeader and InvoiceDetail from prior comment.

 

On the relationship tab, want to view some of the key fields whereas on the visualization tab, I would like to view all the fields available.

 

For example, on Relationship, I would like to show InvoiceHeader and InvoiceDetail and primary and secondary key.  Where on the the Visualization, I would like to see the InvoiceTotal and InvoiceTax columns in InvoiceHeader.

 

Problem I am trying to solve is that I have way too may tables with multiple tables that is preventing me from viewing the appropriate relationships.

 

Thanks again.

Community Support Team
Community Support Team

Re: Dates Table Relationship to show just primary or secondary key

@rps_ken_yu,

 

Based on your description, your requirement is to hide the columns except primary key and secondary key, right? Click File-> Options-> Modeling view, after restart power bi, you will see the data model view option on the left pane, then click the shift and the columns you want to hiden, enable Is_hidden option like below:

Capture.PNG 111.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.