Part V: Understanding Power Pivot and Power Query
FIGURE 35.6
Each table you add to the data model will be placed on its own tab in Power Pivot.
Because the data that you just imported into Power Pivot contained in the tab is a linked Excel table, Power Pivot will
pick up any changes. That is to say, even though the data is a snapshot of the data at the time you added it, the data
automatically updates when you edit the source table in Excel.
Creating relationships between your Power Pivot tables
At this point in our walk-through, Power Pivot knows that we have three tables in the data
model, but it has no idea how these three tables relate to one another. We’ll need to con-
nect these tables by defining relationships between the Customers, Invoice Details, and
Invoice Header tables. We can do so directly within the Power Pivot window.
If you inadvertently closed the Power Pivot window, you can easily call it back up by clicking the Manage command
button on the Power Pivot Ribbon tab. Alternatively, you can click the Manage Data Model command on the Data tab.
- Activate the Power Pivot window, and click the Diagram View command button
on the Home tab. Power Pivot will display a screen that shows a visual representa-
tion of all the tables in the data model (see Figure 35.7).
