Query Timeout Option in Fabric UI

[BalajiL]

I would like to know how to timout the query if it runs longer than x minutes in Fabric. There is a query time out option in ssms or other IDEs. But did not see such option when running query from Fabric Warehouse UI.  At present end users are asked to connect Fabric warehouse via SSMS and given time out options. 

[lbendlin · Accepted solution]

For what it's worth you can set these timeouts on Capacity level (for Direct Query scenarios). We do that extensively on our tenant to prevent runaway queries from locking up our capacities.

[BhaveshPatel · Accepted solution]

Hi @BalajiL 

This is a public cloud real time data. You don't need to worry about timeout in SSMS. It is alway online and available data in Internet ( Public Cloud ).

End users can connect to SSMS at any time ( Software as a Service ) whether its Fabric Datawarehouse or Fabric SQL

[v-veshwara-msft · Accepted solution]

Hi @BalajiL ,

Thanks for reaching out to the Microsoft Fabric Community.

As of now, the Fabric Warehouse UI does not have a query timeout setting directly through the interface. Queries will continue running until they complete or fail due to internal limits, such as resource constraints or service timeouts. Unlike tools like SSMS, there’s currently no option in the UI to set a custom timeout duration.

As you mentioned, using SSMS is currently the practical way to control query timeout by setting it in the connection properties.

Also, as pointed out by @lbendlin, timeout behavior for DirectQuery scenarios can be managed at the capacity level.

Hope this helps. Please reach out for further assistance.

Thank you.

[v-veshwara-msft · Accepted solution]

Hi @BalajiL ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @BalajiL ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @BalajiL ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft · Accepted solution]

Hi @BalajiL ,

Thanks for reaching out to the Microsoft Fabric Community.

As of now, the Fabric Warehouse UI does not have a query timeout setting directly through the interface. Queries will continue running until they complete or fail due to internal limits, such as resource constraints or service timeouts. Unlike tools like SSMS, there’s currently no option in the UI to set a custom timeout duration.

As you mentioned, using SSMS is currently the practical way to control query timeout by setting it in the connection properties.

Also, as pointed out by @lbendlin, timeout behavior for DirectQuery scenarios can be managed at the capacity level.

Hope this helps. Please reach out for further assistance.

Thank you.

[BhaveshPatel · Accepted solution]

Hi @BalajiL 

This is a public cloud real time data. You don't need to worry about timeout in SSMS. It is alway online and available data in Internet ( Public Cloud ).

End users can connect to SSMS at any time ( Software as a Service ) whether its Fabric Datawarehouse or Fabric SQL

[lbendlin · Accepted solution]

For what it's worth you can set these timeouts on Capacity level (for Direct Query scenarios). We do that extensively on our tenant to prevent runaway queries from locking up our capacities.