Direct Query AAD Passthrough Databricks Power BI Requirements

Hi frankvb 

Based on the error message:
ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Bad Status... Status code: 400
usually does not indicate a problem with your Power BI or Databricks setup itself.
This is more commonly caused by network-related issues, such as:

• A firewall blocking or interfering with outbound connections to Databricks.
• A proxy server or network appliance modifying or corrupting HTTP responses.
• TLS/SSL interception tools that alter certificate chains or HTTP headers.
  
  

Here are a few steps you could suggest for troubleshooting: 

• Make sure the host and httpPath fields in your connection string are correct.
  You can verify these in Databricks under: Compute → Cluster → Advanced Options → JDBC/ODBC.
• Try connecting from a different network (for example, a mobile hotspot) to see if the problem is linked to your corporate firewall or proxy.
• Check if any firewall or proxy is blocking or intercepting HTTPS traffic to *.databricks.com.
• Ask your IT or network team to whitelist *.databricks.com and ensure that HTTPS traffic over port 443 is allowed.
• Test your ODBC connection from another tool (like DBeaver or Tableau) to determine if the issue is specific to Power BI.

If these steps don’t resolve the problem, consider raising a Microsoft Fabric Support and Status | Microsoft Fabric with Microsoft or Databricks, and share the full error message and your connection details for further investigation.

Hope this helps !!

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.