Customer experience | Sales, Customer Insights,...

Quarterly Bulk delete all records in CE

(1) Share

Report

Posted on by CU18061702-0

Hello all,

Currently, we have a Dev, UAT, and Prod environments. We want to keep the data clean in these environments from garbage test data. So once a quarter I want to delete most records created in an environment. (Things like custom entity records, Contacts, Accounts, etc.). What's my best approach to automate this? Power automate? (I'm worried about hitting request limit that I have) Bulk delete OOB? (I don't want to create an auto bulk delete for about 50 entities ) or ADF? (Not sure how to use this one but was told it's an option)

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

Based on the replies in the following thread.

【Azure Data Factory v2】 I want to delete the specified Dynamics record. - Microsoft Q&A

Therefore, you might want to consider a combination of Power Automate Flow and bulk deletion to delete records.

For example, handling complex deletion tasks such as associations with other entities in Power Automate.

Simple, straightforward deletion tasks are handled in Bulk Delete.

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi，

I would suggest you use OOB 'Bulk Record Deletion'.

--It is simple and easy to operate.

Power auotmate In addition to the request limitations you mentioned, it uses the ''action to delete records, which also requires selecting the corresponding table.

https://learn.microsoft.com/en-us/power-automate/dataverse/delete-row

You mentioned ADF, the full name should be Azure Data Factory:

https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No