Delete a Row (MDS Add-in for Excel)

Applies to: SQL Server on Windows Azure SQL Managed Instance

Important

Master Data Services (MDS) is removed in SQL Server 2025 (17.x). We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.

In the Master Data Services Add-in for Excel, delete a row of data (a member) from the MDS repository when you no longer want it to be available to users.

Note

Administrators can reactivate deleted members. For more information, see Reactivate a Member or Collection (Master Data Services).

Prerequisites

To perform this procedure:

• You must have permission to the Explorer functional area.

• You must have an active worksheet that contains MDS-managed data.

To delete a MDS-managed row of data

1. Select the entire row you want to delete by clicking the row heading.

2. In the Publish and Validate group, click Delete.

3. On the confirmation dialog box, click Yes.

See Also

Overview: Importing Data from Excel (MDS Add-in for Excel)