Clean up: how to find & delete inactive workspaces?

[mmossel]

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 which workspaces are inactive?

2. Is there a way to automate this process (e.g. email will be sent to owners after 30 inactive days, and automatic deletion after 60 inactive days).

3. Are there additional/other best practices for cleaning the environment?

[Anonymous]

@mmossel 
Did you find any better way to perform this cleanup activity? It would be great if you can help me with the same.

How you performed automation way?

[mmossel]

@Anonymous the unused artifacts api!

Admin - Groups GetUnusedArtifactsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[ibarrau · Accepted solution]

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,