Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other items

[Shreya_Barhate]

I need some clarity on the limits for creating various items under a single tenant. Specifically, I would like to know:

• How many workspaces can be created under a single tenant?
• How many lakehouses can be created within a workspace?
• How many warehouses can be created within a workspace?
• Are there any other relevant limits or quotas for other Fabric items (e.g., data piplines, dataflows, datasets, etc.)?

  Understanding these limits will help me plan my architecture more effectively. Any insights or official documentation links would be greatly appreciated!

[lbendlin · Accepted solution]

It's not a tenant limit, it's a user and item limit

Workspaces in Power BI - Power BI | Microsoft Learn

[Srisakthi]

Hi @lbendlin ,

Could you please share any reference link for this items count

Regards,

Srisakthi

[lbendlin]

Manage workspaces - Microsoft Fabric | Microsoft Learn

[Srisakthi]

Hi @lbendlin ,

But this link doesnt show this information, could you please share any document on this below point

Regards,

Srisakthi

[lbendlin]

Manage workspaces - Microsoft Fabric | Microsoft Learn

Workspace limits

Workspaces can contain a maximum of 1,000 Fabric and Power BI items.

Roles in workspaces in Power BI - Power BI | Microsoft Learn

Considerations and limitations

A limitation to be aware of:

• A person with a Power BI Pro license can be a member of a maximum of 1,000 workspaces.

  Can't find the reference to the ownership limit but we have hit that in our tenant so I know it exists.

[Anonymous · Accepted solution]

Hi @Shreya_Barhate 

In practice, we usually avoid creating too many items in a single workspace to reach the 1000-item limit, as it can negatively impact the efficiency of managing data and permissions.

Additionally, storage and compute capacity limitations can affect the number of items you can actually create. Since items within the same workspace or capacity share the corresponding resources, you may not be able to create more items once the storage or compute reaches its limit. Higher capacity workspaces can handle more items and larger workloads. You may pay more attention to capacity SKU and workspace license mode. Microsoft Fabric concepts - Microsoft Fabric | Microsoft Learn

You will find some suggestions and guidance about the deployment patterns at the tenant level from the document: Deployment patterns for Microsoft Fabric - Azure Architecture Center | Microsoft Learn

Hope this would be helpful. 

Best Regards,
Jing

[lbendlin]

We have hit the 1000 items limit for users. Most of the time it was due to them being unorganized but there were valid reasons too for removing that limit.

[lyjavier]

what do you mean 1000 items limit for users? it means you can create 1000 items within a workspace and another person (assigned to that workspace) can create another 1000 items in the same workspace?

[lbendlin]

Each user can only create 1000 items, regardless of the number of workspaces involved. in addition, each workspace can only contain 1000 items, regardless of number of users.

Those are independent limits.

[lyjavier]

So If I have a Fabric capacity contains 2 workspaces. Is that I can create 2000 items with 1k ones per a workspace?

[lbendlin]

Only if you are two people.

[lbendlin · Accepted solution]

It's not a tenant limit, it's a user and item limit

Workspaces in Power BI - Power BI | Microsoft Learn