list not in use or empty workspace

[Anonymous]

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

[v-yanjiang-msft]

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.

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]

@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]

@Anonymous , Power bi cmdlets.

refer

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

[Anonymous]

@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)

[sdeepa1]

@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.