Enrich data by updating records rather than creating new records
For more information about how to share queries, see Share Queries.Introduction to Microsoft Power Query for Excel Microsoft Power Query for Excel provides an intuitive user interface for data discovery, data transformation and data enrichment.Import data from external data sources With Power Query, you can import data into Excel from a wide variety of data sources.After you connect to a data source, you can shape data to match your data analysis requirements.Shape or transform a query Shape data from multiple data sources by adding, removing or editing query steps to match your data analysis requirements.
Drill down into a related table In Power Query, a column containing a link to a related table has an Entry link or Table link.Group rows in a table Group the values in a number of rows into a single value by grouping the rows based upon the values in one or more columns.For more information about how to group rows, see the Combine data from multiple data sources tutorial.Privacy Levels Privacy levels specify an isolation level that defines the degree that one data source is isolated from other data sources.Insert a custom column into a table Insert an Index or Custom (you define the formula) column to your current query.
An Entry link navigates to a single related record. Expand a column containing a related table Expand a column containing an associated table to reveal the related data.