Chapter 38: Introducing Power Query
38
FIGURE 38.3
Select the correct data source and then click the Edit button.You may have noticed that the Navigator pane shown in Figure 38.3 offers a Load button (next to the Edit button).
The Load button allows you to skip any editing and import your targeted data as is. If you are sure you will not need
to transform or shape your data in any way, you can opt to click the Load button to import the data directly into the
data model or a spreadsheet in your workbook.
Excel has another From Web command button on the Data tab next to the Get Data command. This unfortunate dupli-
cate command is actually the legacy web scraping capability found in all Excel versions going back to Excel 2000.
The Power Query version of the From Web command (found under the Get Data drop-down) goes beyond simple web
scraping. Power Query is able to pull data from advanced web pages, and it is able to manipulate the data. Make
sure you are using the correct feature when pulling data from the Web.