topic Re: "You have reached the maximum number of databases allowed at this time." in SQL database

"You have reached the maximum number of databases allowed at this time."

djurecic — Mon, 03 Feb 2025 22:20:48 GMT

Just got the message below after trying to create a new SQL database.

Anyone have information on what the limits are or how the limit is applied? (per user, per capacity, per tenant, etc.) Didn't see anything about this in the documentation either.

Re: "You have reached the maximum number of databases allowed at this time."

nilendraFabric — Mon, 03 Feb 2025 22:56:28 GMT

Hello djurecic

not official doc but similar discussion here:

Microsoft Fabric does enforce a 1,000-item limit per workspace, encompassing all Fabric and Power BI artifacts, including SQL databases, reports, datasets, lakehouses, and other items. This limit applies regardless of item type, and mixing workloads reduces the available capacity for specific components.

https://community.fabric.microsoft.com/t5/Data-Engineering/Understanding-Limits-for-Creating-Workspaces-Lakehouses/td-p/4257875

Hope this is helpful. If yes please accept the answer

Re: "You have reached the maximum number of databases allowed at this time."

djurecic — Mon, 03 Feb 2025 23:02:11 GMT

Hi nilendraFabric ,

I appreciate the response, but that is not the case here. There are only a few items in the workspace.

Since part of the message is "A higher number of databases will be available in the coming weeks" it seems like this limitation is related to the preview status of Fabric SQL db.

Re: "You have reached the maximum number of databases allowed at this time."

dlevy — Thu, 06 Feb 2025 18:28:40 GMT

Hi djurecic - The limit is 1.5x your capacity - if you have an F2 then it is 3 databases, F64 would be 96 databases, etc. This is a temporary limitation that is scheduled to be removed by the end of next week.

Updated 2/5 to reflect delay in deployment completion from 2/7 to 2/14.

Re: "You have reached the maximum number of databases allowed at this time."

djurecic — Tue, 04 Feb 2025 00:16:14 GMT

Thanks dlevy , appreciate the information!

Re: "You have reached the maximum number of databases allowed at this time."

nilendraFabric — Tue, 04 Feb 2025 03:43:25 GMT

Hello dlevy

This is helpful. Thanks for sharing.
could you please help me where I can find this publically?