Hello,
I have more than 100K records in a table and I want to delete all the records from the table. I am using Dataverse for Teams. Hence bulk delete is not an option for me. This is what I have tried so far based on the response from this community posts:
1. Edit data in excel -> delete records -> publish. This does not seem to be reliable option since it takes enormous amount of time to publish the excel file
2. RemoveIf - does not work
3. Power Automate - Does not work
4. Created view to delete records - Does not work
5. Dataflows - 'Delete rows that no longer exist in the query output' option still keeps few thousand records in the table
I am looking for a time effective and less manual solution which will do the purpose. I really hope someone from the product team provide solution to this problem which is very common.
Regards,
-Nilesh
