Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Bulk delete records in...
Customer experience | Sales, Customer Insights,...
Suggested answer

Bulk delete records in entities

(0) ShareShare
ReportReport
Posted on by Tin 1,558

Hello All,

I want to clean up my CRM data by applying some of the filters in entities, records are enormous count (near to 20 million in per entity). I tried with console, CRM bulk delete OOB option, and XRM tool kit (CDS, Bulk Delete plugin ...etc.) but all the options are not working faster. Can anyone please suggest how we should proceed in case you have faced the same issue? 

While using the console I can able to delete but it's not the fastest way since having huge records will take too many days/weeks to clean up entities, even getting timeout error and OOB bulk delete will take too much time since this will follow sequential series of jobs. 

  • ankit_singhal Profile Picture
    ankit_singhal 560 on at
    RE: Bulk delete records in entities

    You can use SSIS packages, this is fastest way to delete without any error. Second, you can choose scheduled Power automate. Create Power automate and run that after 1 hour and delete some particular count of records like 10,000 each hour.  

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Bulk delete records in entities

    Hello Tin,

    So the case is, that you have multiple tables for which you need to delete records. Am I right?

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • Tin Profile Picture
    Tin 1,558 on at
    RE: Bulk delete records in entities

    this will work on 20 million in per entity count?

  • Tin Profile Picture
    Tin 1,558 on at
    RE: Bulk delete records in entities

    Thanks for the reply, I want to delete near to 20 million per entity and have 20+ entities. If will go with Console this might take more time to delete and we might get a timeout and other errors as well.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Bulk delete records in entities

    Hi,

    Try creating SSIS package using Kingswaysoft.

    www.kingswaysoft.com/.../installation-and-setup

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Bulk delete records in entities

    Hi Tin Latt,

    Use the console application and delete records using ExecuteTransactionRequest. Run one application in ascending of created on and another application in descending order of created on.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans