Drill down into a related table

In Microsoft Power Query for Excel, 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

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

  1. In the Preview editor, click a Table link in a column that is related to the subject table.
 
 
Applies to:
Excel 2013, Excel 2010