Forum Discussion

pvuppala's avatar
pvuppala
Icon for Helper V rankHelper V
2 years ago
Solved

Delete all artifacts in a workspace via API

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 repor...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.