Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Cannot create DataWare house in Fabric

Hi guys,

I am new to Microsoft Fabric and trying to set up a Data Warehouse in Microsoft Fabric. But I keep gettings below error :
Activity ID: 02e4832d-b4ff-4cd2-a2d2-24d475810866
Request ID: a239a6d7-b199-4461-9259-1971d3ae054d
Correlation ID: 187b6435-09bc-27f3-6d9d-ca7324f2bb1e
Status code: 400
Time: Fri Aug 23 2024 19:02:42 GMT+0700 (Indochina Time)
Service version: 13.0.23984.46
Client version: 2408.2.20583-train
Cluster URI: https://wabi-us-central-b-primary-redirect.analysis.windows.net/  

Can someone helps  me with this

Status: Investigating
Comments
Anonymous
Not applicable

Hi @MikeNguyen ,

 

Please ensure that your workspace does not exceed the recommended limit of 40 warehouses and SQL analytics endpoints. Exceeding this limit can cause errors.
You may also verify that you have the necessary permissions to create and manage data warehouses in your workspace.

 

Best regards.
Community Support Team_Caitlyn

 

MikeNguyen
New Member

Hi Caitlyn,

I am sure that we do not have 40 warehouses and SQL analytics endpoints as the fact that I am trying to create the first warehouse in my workspace. 

About the necessary permissions to create and manage, can you provide some guideline where to check these permissions as I can create almost everything at the moment like data flow, datamart, stearming dataset

Please note that I am using trial subscription at the moment.

Binu
Microsoft Employee

I too am facing this ussue since yesterday , when connecting to my Fabric Semantic Models. I am unable to connect to the Semantic models from PBI Desktop, Excel and PBI service.All are throwing the same error

"Couldn't complete the operation because we reached a system limit. We recommend having less than 40 warehouses and SQL analytics endpoints total in the workspace. After removing some items, refresh and try again.The exception was raised by the IDbConnection interface. "

 

In our Fabric Workspace , We do not have any DataWarehouse and we have only 1 SQL analytics endpoint that gets autocreated along with the lakehouse.