The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
We're trying to empty contents of a workspace via an API (Power Automate Flows) for a use-case. I don't see any API to "Delete all content", do we have to run separate DELETE calls for reports, datasets, etc.,?
Pls let me know.
Thanks!
Solved! Go to Solution.
Hi @pvuppala ,
According to the check and test, I found that there is really no API that can realize to clear all the contents in the workspace at one time, you can consider to use the "For each" loop in Automate to loop to get all the contents in the workspace, and then combine with the rest api of PBI to do the batch deletion. and then use PBI's rest api to do batch deletion.
Using loops - Power Automate | Microsoft Learn
Reports - Delete Report - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pvuppala ,
According to the check and test, I found that there is really no API that can realize to clear all the contents in the workspace at one time, you can consider to use the "For each" loop in Automate to loop to get all the contents in the workspace, and then combine with the rest api of PBI to do the batch deletion. and then use PBI's rest api to do batch deletion.
Using loops - Power Automate | Microsoft Learn
Reports - Delete Report - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.