I’m migrating a large SQL Dedicated Pool data warehouse to Fabric Lakehouse.
I’ve run into Fabric’s workspace limit of a thousand items.
What’s the best-practices workaround?
Solved
Fabric workspace limit
+1Best answer by rory.smith
Hi,
according to Microsoft: “We advise admins to evaluate the number of items in workspaces in their tenant and develop a comprehensive plan for managing current and future workspaces.” . TimeXtender will need to come up with some way of spreading items over workspaces as the limit is quite low. As far as I am aware you cannot reach out to Microsoft and have them extend the limit (at least officially), but that is usually a route to take if your customer is large enough.
So it sounds like an Idea needs to be outlined.
https://blog.fabric.microsoft.com/en-US/blog/introduction-of-item-limits-in-a-fabric-workspace/
https://learn.microsoft.com/en-gb/fabric/admin/portal-workspaces#workspace-limits
+8Hi,
according to Microsoft: “We advise admins to evaluate the number of items in workspaces in their tenant and develop a comprehensive plan for managing current and future workspaces.” . TimeXtender will need to come up with some way of spreading items over workspaces as the limit is quite low. As far as I am aware you cannot reach out to Microsoft and have them extend the limit (at least officially), but that is usually a route to take if your customer is large enough.
So it sounds like an Idea needs to be outlined.
https://blog.fabric.microsoft.com/en-US/blog/introduction-of-item-limits-in-a-fabric-workspace/
https://learn.microsoft.com/en-gb/fabric/admin/portal-workspaces#workspace-limits
+1Thanks Dr Rory,
I’m splitting the project into AX, CRM and Everything Else for now.
But I agree … the limit makes no sense … it seems Microsoft doesn’t realize we live in an era of automation and AI where machines increasingly do the hard work, including the housekeeping.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
