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

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,591)