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?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!