Introduction to Power Query
Power Query is also part of the Power BI family and allows you to extract and load data from a huge range of sources, which includes data from outside a file or database and from web pages. It is considered a data grabber (or data shaper) as you feed data into Power Pivot from Power Query. When working with Excel data, you can create a data model by adding tables using data imported from various sources through Power Query, then use the Add to Data Model checkbox on import. Then, you use Power Pivot to create links (relationships) between tables. Both Power Query and Power Pivot allow you to import data sources, but Power Query wins this battle since it provides more choices and has a smaller file size.
You can pull data into existing Power Pivot or Excel tables and then shape the data before you use the data again in Excel. Power Query is available in Excel and Power BI, and the output of any transformed or shaped data can be sent to Excel or Power...