cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Intermittent connectivity issues between Power BI and Databricks

Malthe
Contributor III

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:

0 REPLIES 0