Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

list not in use or empty workspace

a lot of PBI workspace were created automatically when SharePoint team site was created(~500)

Can some one suggest to find a quick way to list all the workspaces which are empty(no reports/dataset in them) or not been use for long time.

And then also remove them

5 REPLIES 5
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

By my reserch, for the existing empty workspaces, you can try to run the Power BI API calls from PowerShell.

Additionally, you can  enable the block classic workspace creation tenant setting in the Power BI Admin portal. Thus, 

newly created Office 365 Groups won’t appear as classic workspaces in the Power BI workspaces list.

 

vkalyjmsft_0-1640592804144.png

Reference: Updated timeline for upgrading classic workspaces | Microsoft Power BI Blog | Microsoft Power BI

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

@v-yanjiang-msft Yes we have already enabled the option to stop creating workspaces. My question here is, Is there any automated script that is available that can iterate through the list of workspaces and return the empty workspaces.

amitchandak
Super User
Super User

@Anonymous , Power bi cmdlets.

refer

https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak  the mentioned URL have list of all Cmdlets, specifically what I am looking for is a script  which will list the workspaces(empty or not used)

@Anonymous Hi, by any chance, have you been able to find the script to retrieve the list of empty workspaces ? I am looking for the same now and I came across this discussion.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.