Drill down into a related table (Power Query)

Important   This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Designer, which is a stand-alone report authoring and data transformation tool for Power BI.

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

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

  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



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

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

Thank you for your feedback!

Support resources

Change language