get the number of workspaces contained in my organization's tenant

[Anonymous]

Hello to all,

What is the best way to get the number of workspaces contained in my organization's tenant. I want to be able to identify the premium capacity spaces from those that are not and be able to count them. Thanks

[Tutu_in_YYC]

Hi Charly,

You need to first be a Power BI Admin. This role can be assigned to you in Azure AD by the Global Admin.

Then go to power BI service > Settings > Admin Portal > Workspaces

You can see the type of workspaces and the premium capacity. Export the list to Excel.

[Anonymous]

thank you however there are several types. Can you enlighten me? ( see the screen)

[Tutu_in_YYC · Accepted solution]

Workspace = Power BI Workspace ( New experience) 

Group = Teams/0365 Group/Class Power Workspace
Personalgroup/Personal = My Workspace

Here is some info on classic workspace and new experience power bi workspace
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

You can publish report to all 3 types of workspaces. For Capacite_P1_0, I have never seen it before.

[Anonymous]

capacity p1 is our premium capacity

[Tutu_in_YYC]

It is odd that the premium capacity is appearing as a type of group. Could it be that it is grouping all your premium workspaces under that name?

[Anonymous]

I don't think so because when I filter on it it lists only two workspaces