Governance: How to bulk upgrade group-based Power BI workspaces and delete those with no content?

Dear all,

I'm currently trying to resolve the conundrum of useless O365-group based Power BI workspaces.

We have a lot of O365 groups that still have their purpose, but the attached Power BI workspace is not used and empty.

In the meantime also an option in the Tenant Settings has appeared that blocks classic workspace creation, but this doesn't help with existing ones.

I can add myself as an owner to each workspace to trigger the upgrade and then delete the Power BI workspace.

But doing that for hundreds of workspaces manually doesn't look very appealing 🙂

Is there a way to automate this process? A first look at Power Shell and the REST API didn't help.

I think I can use parts of the API to add myself as a user and determine the content. But I found no upgrade option in the API.

How do you solve this issue in your organization?