Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
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
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
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.