Databricks ODBC driver error

[The_Bishop]

I have suddently started seeing in Power Query, when working with Databricks sources:

DataSource.MissingClientLibrary: The Databricks ODBC driver is not installed on the host. Please install the appropriate driver.

I noticed yesterday that my version of Desktop had moved to October 2024, which I thought was odd, but it is now back to August 2024, following another update from the store today.

The Databricks colleague I would usually discuss this with is on leave, so I am on my own for a few days. I realise what the message is saying, but we haven't done any work around that.

Does anyone else have any ideas? This has been the way we've worked for about 2 years now and this is the first time this has ever come up.

[mohdmohideen200]

The only portion that is not a full sentence is the error label

[The_Bishop]

I don't know what that means, in this context. The error is fixed, anyway.

[mohdmohideen200]

"In this context, 'DMTS' likely refers to an internal system component."

[czar]

Is anyone having this issue when trying to refresh a dataflow. this error just popped up for me while trying to refresh a dataflow.

[FrankH12345]

Having this error since yesterday night in the Power BI service and Power BI desktop. The model worked fine before that and no changes have been done. It was running perfect for months.  

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: error code: 0. ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: error code: 0.. DataSourceKind = Databricks. DataSourcePath = {"host":"adb-XXXXXX.6.azuredatabricks.net","httpPath":"\/sql\/1.0\/warehouses\/XXXXXX"}. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. Table: DIM_XXXX.

A single reload of the tables is causing no problems, but a full reload of the model gives back errors on multiple tables. Is anyone facing the same issue or has a solution to this problem? Much appreciated.

[Astrocastro]

Same issue with August version and databricks connections

Solution that worked for me coming back into the office this morning:

Uninstall PBI ->
  Restart ->
    install version 2.132.1053.0 here https://www.microsoft.com/en-us/download/details.aspx?id=58494 ->
      Restart->
        Refresh all->

          Repointed a couple connections in the Navigation step.

Good to go

[sachithpo]

i was using August vesion , suddenly gave me the same error , i was quering trough native query, 

then i donloaded the July version, open the dashboard then its working fine, 

then  i close  it and open the same dashboard using August version as its running fine too , 

[The_Bishop]

The latest release from the MS Store (19/09/20/24) sorts this.

[SI_Eddy]

Still broken for me, and not update button. 

Will stick with July for now

[trunks]

It's weird. 

[Working] Earlier it was working for the same version and suddenly it stops refreshing. 

I had August 2024 version. 

✔️Anyways, i have reinstalled July 2024 version, it's good. 

let's see if this issue is resolved for the new versions from Power BI Team.

P.S. Try to restart the laptop, because you might see pixels and fonts issues after installing July'24 Update.

[itsme2003always]

Hi, I also face the same, unable to connect to databricks now.

Can you share the link of the version for which it still works.

Also, won't this affect the reports we publish, like as of now with previous version it would work for our system, but for power BI reports in browser, the error persists

[The_Bishop]

https://www.microsoft.com/en-us/download/details.aspx?id=58494&msockid=37c517d15efc6ab502c903385f436... however the MS Store version is now fixed for this.

[SilviD]

Hi all,

a colleague of mine started having the issue yesterday and he had the August 2024 version. At the time my desktop version was showing October 2024 and all was running. Today on file open I got another message first :

Report layout differences might exist
This Power BI report file may have some features that aren't available in Power BI Desktop until the next release.
If you need to see the latest version you worked with on the web (app.powerbi.com), please view the report there. We're sorry for any inconvenience.

And now if I start modifying the queries or try a refresh, the following error message appears:

The Databricks ODBC driver is not installed on the host. Please install the appropriate driver.

I've tried installing the driver but that didn't fix anything. We have raised a MS support ticket.

And the desktop version of Power BI reads August 2024 today. So probably it reverted overnight.

[v-xinruzhu-msft · Accepted solution]

Hi @The_Bishop 

This is a issue, the Engineers are working on this, and if you installed Desktop from Microsoft Store, you may consider re-downloading Desktop from the  website  and installing it before trying to connect to the data source.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[The_Bishop]

Going back to the July version has got me working again for now.

[JamiBoy]

It worked for me after moving to the July version. Thanks. 

[The_Bishop]

I got this reposnse from MS:

 Issue: - DataSource.MissingClientLibrary: The Databricks ODBC driver is not installed on the host. Please install the appropriate driver.

From your statement we observed that you are referencing Databricks data sources in Power Query, you are getting the error as "DataSource.MissingClientLibrary: The Databricks ODBC driver is not installed on the host Please install the appropriate driver". And the version of your powerbi desktop is August.

Currently we are seeing few issues with August and October versions . Please try to download the July version & check the behavior

Link to download:    https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

If this does not fix the issue, kindly install the driver by following the steps given in the document

Link: Download and install the Databricks ODBC Driver - Azure Databricks | Microsoft Learn
 

In majority of the cases the issue got resolved after reinstalling the drivers.

[SI_Eddy]

This temp fix worked for me, thanks! 

Hopefully they sort quickly, looks as though them releasing dark mode came with a few issues.....

[mjkusler]

I did all that and still have issues.

[sduffy]

Go vote this topic up under issues: https://community.fabric.microsoft.com/t5/Issues/Unable-to-connect-to-Databricks-from-Power-BI-Deskt...