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
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.
No comments:
Post a Comment