Forum Discussion
Warehouse Fabric GUI does not update
Hello Alexander_Faber ,
Thank you for reaching out to the Microsoft Fabric community forum. The error you're seeing indicates a timeout issue in the Fabric UI, while Azure Data Studio is functioning correctly. Also thank you nilendraFabric for your inputs
To fix this, try manually refreshing the schema by going to Warehouse > Manage Tables > Refresh Schema. If your queries are large, they might be timing out before completion, so consider breaking them into smaller parts for better performance.
If you're using Power BI, increase the Command Timeout in File > Options & Settings > Options > Query Execution. Additionally, try pausing and resuming the warehouse from the Fabric UI or reconnecting the SQL Endpoint via Settings > Manage Connections > Reconnect SQL Endpoint.
Check your Fabric capacity and resource limits, as heavy workloads can cause timeouts. If the issue persists, verify the Fabric Service Health Dashboard for any outages.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
I have opened a ticket for that and support is still investigating the issue.
Using parts of this code I can find also batch jobs of type Monitor on the SQL endpoint
Workaround for delays in the automatically generated schema in the SQL analytics endpoint of the Lakehouse in Fabric | by Mark Pryce-Maher | Medium
These batch jobs also list the new tables. But there are other jobs with a refresh action from the UI that turns up with an error:
{'batchId': 'aaaaaaa-adb1-4a34-8786-aaaaaaaaaaaaaa-03be-4582-b90b-e90fbb204dec$2025-02-27T16:19:35.5346803Z@f725a144-300c-4e90-bbd1-b31674256bee',
'startTimeStamp': '2025-02-27T16:19:35.72',
'endTimeStamp': '2025-02-27T16:32:55.66',
'progressState': 'failure',
'errorData': {'error': {'code': 'InternalError',
'pbi.error': {'code': 'InternalError',
'parameters': {'ErrorMessage': 'The SQL query failed while running. Message=[METADATA DB] <ccon>Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</ccon>, Code=-2, State=0',
'HttpStatusCode': '500'},
'details': []}}},
'batchType': 'metadataRefresh'}