Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I've read numerous related forum posts, none of which provides a clear-cut answer to the question: what is the limit to the number of new/modern/v2 workspaces one can have in a single Power BI tenant? Is it unlimited?
There were answers for the Office 365 based (old) workspaces, but I can't find the answer for the new workspaces. This link: Organize work in the new workspaces in Power BI mentions that "A person with a Power BI Pro license can be a member of a maximum 1,000 workspaces." but doesn't address the total number of workspaces possible within a tenant.
Any help would be appreciated!
Thanks,
Ed
I've been wanting a decisive answer to this question as well. Unable to find any more than you've mentioned I decided to put it to the test. I created a new AAD tenant, setup a Power BI Pro user, then wrote a script to create workspaces using the Pro user as a master account. I successfully created 10,336 workspaces before I finally turned the script off.
A few take-aways...
1.) It appears the 1,000 workspace max for a Pro user is not actually valid, at least for workspaces created via the API, because every one of those workspaces has that Pro user as an admin member.
2.) Still no clear-cut answer, but I can say for certain you can create at least 10 thousand workspaces in a single Power BI tenant using a single Pro user via the REST API.
Mike
Awesome - thanks for doing that.
I had a similar idea but thought it was futile given the documented 1000-workspaces-per-user constraint. Evidently we shouldn't trust the docs 🙂
Ed
I am not aware of anything super clear on this. My guess is that it is in the 500K range or it is dependent upon the total amount of storage space you get in your tenant. See this thread:
https://community.powerbi.com/t5/Service/How-many-APP-WorkSpaces-can-be-create/td-p/250022
There's also this: https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi.
I suppose another way to look at this is if a Pro user can only be a member of 1,000 workspaces and if no Pro users share any workspaces, then the limit is 1,000 * # Users
Is this just a theoretical excercise or what is the concern here?
Hi @Greg_Deckler, thanks for your quick response.
Yup - that's pretty much all that I've found.
It's a theoretical question prompted by an ISV-to-thousands-of-customers Power BI Embedded scenario. We were making architectural decisions, and this point was raised. There isn't a pressing need for a definitive answer to this question as we've gone with an architecture where we won't be needing an inordinate amount of workspaces, but it would still be nice to get some clarification for future reference, if an undocumented limit exists.
With the old Office 365-tied workspaces, it was noted in various places (including that which you shared) that 500k was the limit (although I'd be impressed if people reached that limit!), but it's not so clear with the new workspaces. You're right in that we wouldn't be able to utilize any more workspaces than #Users * 1000, but if we had 1000 users, that could theoretically allow us to have 1 million workspaces (again - highly unlikely, but possible given the documented constraints).
Thanks again,
Ed
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.