Part V: Understanding Power Pivot and Power Query
FIGURE 36.11
The Manage Relationships dialog box enables you to make changes to the relationships in
the internal data model.Here, you will find the following commands:New Create a new relationship between two tables in the internal data model.
Auto-Detect Have Power Pivot automatically detect and create relationships based on the
data in your tables.
Edit Alter the selected relationship.
Activate Enforce the selected relationship, telling Excel to consider the relationship when
aggregating and analyzing the data in the internal data model.
Deactivate Turn off the selected relationship, telling Excel to ignore the relationship
when aggregating and analyzing the data in the internal data model.
Delete Remove the selected relationship.Removing a Table from the Internal Data Model
You might find that you want to remove a table or data source altogether from the inter-
nal data model. To do so, click the Data tab in the Ribbon and then click the Queries
& Connections command. The Queries & Connections task pane shown in Figure 36.12
activates.