Part V: Understanding Power Pivot and Power Query
- In Excel, select the Get Data command in the Get & Transform Data group on
the Data tab and then select From Other Sources ➪ From Web (see Figure 38.1).
FIGURE 38.1
Starting a Power Query web query
- In the dialog box that appears (see Figure 38.2), enter the URL for the data
that you need, in this case, http://finance.yahoo.com/q/hp?s=MSFT.
FIGURE 38.2
Enter the target URL containing the data you need.
After a bit of gyrating, the Navigator pane shown in Figure 38.3 appears. Here, you
select the data source you want extracted. You can also click each table to see a
preview of the data.
- In this case, the table labeled Table 2 holds the historical stock data you need,
so click Table 2 and then click the Edit button.
