Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

Very poor CDS performance in deleting records, any ideas?

It takes > 5 minutes to delete just 500 of the 5,000 records from a CDS entity by using the following code as suggested in the documentation for the Clear function

RemoveIf(CdsEntity, true)

This is very poor perfomance, and there is no way to delete all records at once.

Does anyone have a better idea of how to truncate a CDS entity?

Memorable Member
Memorable Member

If the issue just started it might be related to the overall CDS issue that others are reporting (including myself)


Check the forum post here, lots of other CDS related issues all of a sudden:


No word at all on a fix from MS (as per usual)

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,442)