Truncate a Dataverse table using a Dataflow in Azure Data Factory.

Question

Anonymous

Hi Team,

I want to truncate a table present in dataverse using adf-dataflow. Please guide me how it can be done

Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-11-04T10:25:27.6333333+00:00

Saurav Panda [C] Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-11-04T10:25:27.6333333+00:00

Saurav Panda [C] Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Amira Bedhiafi 42,941 MVP Volunteer Moderator

Hello Saurav !

Thank you for posting on Microsoft Learn Q&A.

You can’t truncate a Dataverse table because it doesn’t support TRUNCATE so you have to delete rows.

If you specifically want to use a data flow, you can mark every row for delete and let the Dataverse/Dynamics 365 sink remove them.

For large volumes, it’s usually faster to submit a BulkDelete job through the Dataverse Web API from an ADF pipeline.

0 comments