Forum Discussion

allanw's avatar
allanw
Icon for Helper I rankHelper I
10 months ago
Solved

Power BI Model based on Databricks Serverless SQL Warehouse refresh failure - ODBC: ERROR [HY000]

Hello,   We have some Power BI semantic models that are refreshed based on data from Azure Databricks, served by Serverless SQL Warehouse compute. We have Power BI VNet gateway connection set up. ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    10 months ago

    Hi allanw ,

    Thanks for reaching out to Microsoft Fabric Community Forum.

    The specific error message you're seeing, ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server, suggests that there might be connectivity issues between Power BI and your Azure Databricks SQL Warehouse.

     

    Here are some steps and considerations that might help you resolve this issue:

    • Ensure the SQL Warehouse is Running (not stopped or scaling)
    • Verify Access Token used in Power BI is valid and not expired regenerate and update if needed.
    • Confirm the Server Hostname and HTTP Path values are correct in the data source settings,From the gateway machine, make sure outbound HTTPS connectivity to Databricks endpoint is allowed: No firewall/proxy blocking ,Port 443 open outbound
    • On the gateway machine, run an ODBC test using the same driver and token. Ensure the latest Databricks ODBC driver is installed.
    • Restart the On-premises Data Gateway and ensure the data source mapping is correct and online
    • Retry the dataset refresh in Power BI Service after the above validations.

     

    Hope this helps!!

    Thank You.

anilgavhane's avatar
anilgavhane
Icon for Super User rankSuper User
10 months ago

  

Note-AI helped me to format this solution.

 

 

1 Check Warehouse Status

Go to Databricks → SQL → Warehouses → Serverless warehouse.

Ensure it is running.

Disable “Auto-stop” temporarily and test refresh.

2.Test Connection from Gateway VM

On the machine hosting the Power BI VNet Gateway, run:

 

 
# test TCP connectivity telnet adb-<workspace>.azuredatabricks.net 443
 

If the connection fails → VNet / NSG / firewall issue.

3. Update ODBC Driver

Ensure Microsoft ODBC Driver for Databricks is latest version:

Databricks ODBC Driver Download

Restart the gateway after update.

4. Check Power BI Dataset Settings

Go to Power BI Service → Dataset → Settings → Data Source Credentials.

Re-enter Databricks credentials (PAT token or OAuth).

Ensure the VNet gateway is selected correctly.

5. Enable Query Logging / Monitor

In Databricks:

SQL → Query History → Check for failed / long-running queries.

Verify if the warehouse received the query request at all.

6. Optional: Increase Gateway Timeout

Power BI VNet gateway has a timeout setting (default ~2 minutes).

For large datasets, increase the timeout or split queries.

allanw