Capacity Question: we can't get enough capacity for optimal performance in time. Why?

[alfBI]

Hi,

Since 2 days ago a pipeline that orchestrates the refresh of a semantic model is failing. When checking the error log corresponding to the failed refresh following message does appear

lsghu2ekgslepk3vgjdnxbe6rm-h4tk3iejyyfurpgszqnfzsiwt4.datawarehouse.fabric.microsoft.com;Star. Message = [This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.]\r\nStatement

The semantic model is based on an import model querying data from a Fabric Warehouse

The error message seems to clearly indicate some problems with the capacity resources available when running the queries to import the data.

My doubt is: This message means that we have exceed capacity limits? The model workspace has assigned a F64 SKU and checking on Fabric capacity report we see that we are far from excedeeing its total usage (around 25%)

I understand that if at the same time multiple process are consuming more than 64 CUs they are smoothed across the day. Why this does not happen when I am refreshing the models? why are these queries rejected? 

Thanks

[v-lgarikapat]

Hi @alfBI ,

Thanks for reaching out to the Microsoft fabric community forum.

Thank you for your detailed explanation and screenshots.

To help resolve the issue, I recommend raising a support ticket so the support team can assist you further.
Please refer to the following link for instructions on how to create a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi

[v-lgarikapat]

Hi @alfBI ,

Just following up to check if you had a chance to raise the support ticket.
Please let me know if you need any additional details from my side.

Best regards,
Lakshmi

[alfBI · Accepted solution]

Hi, Problems seems that was related with the issue reported on FAbric support page. Problems has not appeared more after that

Thx

[v-lgarikapat]

Hi @alfBI ,

Thanks for sharing the update. Glad to hear the issue hasn’t appeared again.

Best Regards,

Lakshmi

[marekb]

I'm having the same issue today.  There is a note on the support page: 

Fabric Customers in West Europe region may experience intermittent performance issues when running SQL queries for their Datawarehouse and Lakewarehouse artifacts, leading to long query executions. Engineers are investigating the issue and an update will be provided soon.

Microsoft Fabric service status

I hope they will get this fixed soon.

[AutumnBeast]

I'm having the same issue, but with a simple 
Select top 100 * from dbo.sometable in a lakehouse. 

Never had the error message before, luckily all the normal processes are currently still working.
Would love to know what causes this, since it does not seem to be anything related to data size.