The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.
@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.
@Anonymous , Power bi cmdlets.
refer
https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps
@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.
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
96 | |
74 | |
67 | |
52 | |
51 |