Is there an easy (fast) way to empty a table? Equivalent to TRUNCATE in SQL

(0) Share

Report

Posted on by molegris

157

Hi,

I've been searching the web and it baffles me that I can't find any ways to truncate a table in Dataverse. I'm working with a table that had 86,000 rows. It's still in the development phase so we are frequently adding/removing/tuning columns. It's a real pain to have to empty the tables with the Xrm Tools. It takes FOREVER!

The only alternative we found is the delete and recreate the table... and adding all the columns 1 by 1. We also tried something with the Continous Integration tools on Azure DevOps but that's also a pain to clear the env. then reinstall the solution every time.

Am I missing something? I feel this is a basic fucntionnality that any developers would want... it must be exists! Does it? 🙂

thanks

--mo

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @molegris,

Have you already tried turning off auditing in your dev environment? That could be a real performance hit especially when bulk deleting.

That said, if you're doing this very frequently and it's still taking too long to bulk delete, it's probably in your best interest to just build a DevOps pipeline that you can run on demand to spin up a new dev environment, import the solution, and import your configuration data + optional test data.

The option that executes faster depends on your customizations, but for obvious reasons the DevOps pipeline brings you additional benefit.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
molegris 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. I've seen the audit option when creating attributs but I was not aware of the global OFF switch. Can you tell me how to do it? (I do have admin rights)
ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @molegris,

There is a few levels of auditing that need to be enabled for field level auditing to occur. First is at the environment level. In Power Platform Admin Center > Environments > Pick your environment >Settings > Audit and Logs > Audit Settings > Uncheck Start Auditing. This is sufficient to broadly turn off auditing in your dev environment for your purposes.

Second level is at the table level which you can toggle on/off in its settings in the Maker Portal.

The third level is at the specific column (field) level, which you can toggle in column settings.

More information on auditing at the reference below.

https://docs.microsoft.com/en-us/power-platform/admin/audit-data-user-activity#startstop-auditing-and-set-retention-policy

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.