Drill down into a related table (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

In Power Query, a column containing a link to a related table has an Entry link or Table link. An Entry link navigates to a single related record. A Table link navigates to a related table. A link represents navigation properties in a data source within a relational model. For an OData feed, navigation properties represent an entity with a foreign key association. For a database, such as SQL Server, navigation properties represent foreign key relationships in the database.

I want to

Navigate to an Entry link

Navigate to a Table link

Navigate to an Entry link

When you navigate to an Entry link, Power Query displays a page containing a single record from the related table. An Entry link has a one to one relationship with a subject table.

To navigate to an Entry link

  1. In the Preview editor, click an Entry link in a column that is related to the subject table.

Navigate to a Table link

When you navigate to a Table link in a column that is related many related records, Power Query displays a data grid containing rows from the related table. A Table link has a one to many relationship with the subject table.

To navigate to a Table link, in the Preview editor, click a Table link in a column that is related to the subject table.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×