We're experiencing connectivity issues between Power BI (refreshing a dataset) and Databricks.
On the Databricks side, we're using a SQL Warehouse (serverless), which reports queries timing out:
Query has been timed out due to inactivity.
On the Power BI side, we see the connection closing unexpectedly:
Data source error: DataSource.Error: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: connect() failed: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
These are relatively small queries, normally responding in two minutes or less.
What could explain this situation? It's normally working fine and we have made no changes.
Related issues: