Delete Relationships (SSAS Tabular)
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
You can delete existing relationships by using the model designer in Diagram View or by using the Manage Relationships dialog box. For information about how relationships are used in tabular models, see Relationships (SSAS Tabular).
Considerations for Deleting Relationships
Keep the following issues in mind when deciding whether to delete a relationship:
There is no way to undo the deletion of a relationship. You can re-create the relationship, but this action requires a complete recalculation of formulas in the model. Therefore, always check first before deleting a relationship that is used in formulas.
Deleting a relationship between two tables can cause errors in formulas that reference these tables.
The Data Analysis Expression (DAX) RELATED function uses the relationships between tables to look up related values in another table. It will return different results after the relationship is deleted. For more information, see the RELATED Function (DAX).
In addition to changing PivotTable and formula results, both the creation and deletion of relationships will cause the workbook to be recalculated, which can take some time.
To delete a relationship by using Diagram View
In SQL Server Data Tools (SSDT), click the Model menu, then point to Model View, and then click Diagram View.
Right-click a relationship line between two tables, and then click Delete.
To delete a relationship by using the Manage Relationships dialog box
In SQL Server Data Tools, click the Table menu, and then click Manage Relationships.
In the Manage Relationships dialog box, select one or more relationships from the list.
To select multiple relationships, hold down CTRL while you click each relationship.
Click Delete Relationship.
In the Manage Relationships dialog box, click Close.