Part V: Understanding Power Pivot and Power Query
When you click the Edit button, Power Query activates a new Power Query Editor
window, which contains its own Ribbon and a preview pane that shows a preview of
the data (see Figure 38.4). Here, you can apply certain actions to shape, clean, and
transform the data before importing.
FIGURE 38.4
The Power Query Editor window allows you to shape, clean, and transform data.
Preview Pane
Formula Bar
Query
Settings
The idea is to work with each column shown in the Power Query Editor, apply-
ing the necessary actions that will give you the data and structure you need.
You’ll dive deeper into column actions later in this chapter. For now, you need to
continue toward the goal of getting the last 30 days of stock prices for Microsoft
Corporation.
- Right-click the Date field to see the available column actions, as shown in
Figure 38.5. Select Change Type and then Date to ensure that the Date field is
formatted as a proper date.
