Bulk delete

Completed

Microsoft Dataverse includes basic bulk row deletion functionality. The purpose of bulk delete is to remove stale data and manage the consumption of system storage by deleting data that you no longer need.

With bulk deletion you can perform the following operations:

  • Delete records for a specified table.

  • Delete data across multiple tables.

  • Receive email notifications when a bulk deletion finishes.

  • Delete data periodically.

  • Schedule the start time of a recurring bulk delete.

  • Retrieve the information about the failures that occurred during a bulk deletion.

Bulk delete is managed in the environment's settings in the Power Platform admin center under the Data management section. Dataverse has many bulk delete jobs to clean up its own data.

Bulk delete jobs are created by using a wizard.

Screenshot of bulk delete wizard.

You select the table and then either use an existing view or create your own query to determine the rows to check for duplicates. You can then run the job or schedule it to run every 7, 30, 90, 180, or 365 days.

Bulk delete jobs run as scheduled background jobs.

After the job has run, you can review the number of rows it has deleted.

Important

Data deleted by bulk delete jobs cannot be recovered.