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

[trutz]

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?

[Greg_Deckler]

@trutz - Unfortunately I do not have a good answer for you. 

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[trutz · Accepted solution]

Hi @Greg_Deckler 

I created the service ticket, but it is as it is. No API today and just the reminder to vote on the following idea item: https://ideas.powerbi.com/ideas/idea/?ideaid=c7315306-82d1-42c8-bc69-c39016b8beb5

I added my vote. Maybe you want to add yours too.

[Greg_Deckler]

@trutz Voted for!