Dates Table Relationship to show just primary or secondary key

[rps_ken_yu]

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?

[Greg_Deckler]

Modeling tab | Manage Relationships

[rps_ken_yu]

@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?

[Greg_Deckler]

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?

[rps_ken_yu]

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.

[v-yuta-msft · Accepted solution]

@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:

  

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.