Managing Relationship

Users can edit or delete an existing relationship in the data model.

Steps to see all the Existing Relationships in the Data Model

Step 1: Click the design tab in the Power pivot window.

Step 2: In the Relationship group, click on Manage the Relationship.  

A dialog box appears with all the existing relationships in the data model.

Steps to Edit a Relationship

Step 1: Select the relationship you want to edit.

Step 2: Select the edit button. A dialog box appears for the edit relationship.

Step 3: Now you can make the required changes. 

Step 4: The required changes will reflect on your data after clicking “OK”.  

Steps to Delete the Relationship

Step 1: Select the relationship you want to delete.

Step 2: Select the delete button. 

Note: A alert message will pop up showing how the affected tables will affect the reports after deleting the relationship.

Step 3: Click Ok if you surely want to delete that relationship. The relationship is deleted.

Power Pivot is something that helps us in relating between two different data sets which are in two different worksheets. We can manage and relate any type of data using Power Pivot. It is used for data analysis and creates many different data models. we can collect large data from different sheets and can apply or perform any relation between them. Power Pivot is usable for tables only. If we have any dataset then we need to convert that dataset into tables before using Power Pivot.