topic Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i in Data Engineering

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

Shreya_Barhate — Fri, 25 Oct 2024 10:02:29 GMT

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!

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Fri, 25 Oct 2024 21:55:53 GMT

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

Workspaces in Power BI - Power BI | Microsoft Learn

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

Anonymous — Mon, 28 Oct 2024 06:57:16 GMT

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

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Mon, 28 Oct 2024 11:23:56 GMT

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.

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lyjavier — Fri, 07 Feb 2025 11:15:37 GMT

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?

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Fri, 07 Feb 2025 21:26:08 GMT

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.

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lyjavier — Mon, 10 Feb 2025 09:32:57 GMT

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

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Mon, 10 Feb 2025 11:36:12 GMT

Only if you are two people.

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

Srisakthi — Fri, 21 Feb 2025 10:30:13 GMT

Hi @lbendlin ,

Could you please share any reference link for this items count

Regards,

Srisakthi

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Fri, 21 Feb 2025 22:50:56 GMT

Manage workspaces - Microsoft Fabric | Microsoft Learn

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

Srisakthi — Mon, 03 Mar 2025 11:23:44 GMT

Hi @lbendlin ,

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

Regards,

Srisakthi

Re: Understanding Limits for Creating Workspaces, Lakehouses, Warehouses, Data pipelines and other i

lbendlin — Mon, 03 Mar 2025 14:51:18 GMT

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.