Forum Discussion

mmossel's avatar
mmossel
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Clean up: how to find & delete inactive workspaces?

Hi,   To clean up our Power BI environment, we want to delete all inactive workspaces (e.g. no report/dashboard is viewed in the past 60 days). Three questions about that:   1. How do we find out...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    Hi. I think the only way might be getting data of activity events from rest API. That data shows the activities of the whole tenant. It will depend on your definition of "inactive" in order to proceed. The usage metrics from the PBI service will show 30 days ago, the rest API will show 90 days ago and if you want more you can write a script to use the rest API in order to store the events data as historic.

    Once you have that data you might be able to write a script checking the "inactivity". If 120 days without use is inactive for you, that would be the script rule to delete it. You can delete the group/workspace.

    I hope that helps,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
5 years ago

Hi. I think the only way might be getting data of activity events from rest API. That data shows the activities of the whole tenant. It will depend on your definition of "inactive" in order to proceed. The usage metrics from the PBI service will show 30 days ago, the rest API will show 90 days ago and if you want more you can write a script to use the rest API in order to store the events data as historic.

Once you have that data you might be able to write a script checking the "inactivity". If 120 days without use is inactive for you, that would be the script rule to delete it. You can delete the group/workspace.

I hope that helps,