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.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×