topic Re: Databricks ODBC driver error in Power Query

Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 14:18:43 GMT

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.

Re: Databricks ODBC driver error

dharmendars007 — Wed, 18 Sep 2024 14:16:24 GMT

Hello The_Bishop ,

Please refer the below link to understand on conneting the Power BI to Databricks through ODBC driver.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

Re: Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 14:21:08 GMT

Hi, there - thanks for responding. I can't see it on your LinkedIn. Do you have a direct link to the article? For the last 2 years, I seem to have been working without the ODBC driver installed locally (as it was bundled in Desktop). I guess it no longer is, but I haven't seen any release notes mentioning this.

Re: Databricks ODBC driver error

Amberr567 — Wed, 18 Sep 2024 15:06:53 GMT

I just wanted to comment that I, too, am randomly having this issue. The report has been working fine since creation 2 months ago and is now returning the same error you are receiving. I wonder if it is update related, because I can't imagine that you and I both have the identical issue at the same time + have no driver changes to our knowledge.

Re: Databricks ODBC driver error

sduffy — Wed, 18 Sep 2024 15:18:13 GMT

We are also facing this issue as of this morning too, although published models out in the workspace seem to be refreshing fine but trying to refresh an existing connection in desktop or create a new one from scratch are both getting this error message.

Re: Databricks ODBC driver error

Amberr567 — Wed, 18 Sep 2024 15:20:55 GMT

This is my exact experience

Re: Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 15:23:14 GMT

Yes, our refreshes are OK, too. Thankfully.

Re: Databricks ODBC driver error

nawhiteley — Wed, 18 Sep 2024 16:00:12 GMT

Having the exact same problem. I am still on the August version though (Version: 2.132.1053.0 64-bit (August 2024)).

Dataflows are completing fine in the service and this exact same desktop file was executing the exact same queries just fine yesterday. It doesn't feel like a Databricks issue to me.

I tried grabbing a new connection file for Power BI from Databricks and it has the same issue

Re: Databricks ODBC driver error

sduffy — Wed, 18 Sep 2024 16:04:58 GMT

Go vote this topic up under issues: https://community.fabric.microsoft.com/t5/Issues/Unable-to-connect-to-Databricks-from-Power-BI-Desktop-ODBC-error/idc-p/4157033#M109353

Re: Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 16:07:23 GMT

Thanks. Done.

Re: Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 16:08:04 GMT

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-2024-07_x64.exe

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.

Re: Databricks ODBC driver error

mjkusler — Wed, 18 Sep 2024 16:32:19 GMT

I did all that and still have issues.

Re: Databricks ODBC driver error

The_Bishop — Wed, 18 Sep 2024 16:35:41 GMT

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

Re: Databricks ODBC driver error

JamiBoy — Thu, 19 Sep 2024 01:07:05 GMT

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

Re: Databricks ODBC driver error

Anonymous — Thu, 19 Sep 2024 02:13:28 GMT

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.

Re: Databricks ODBC driver error

Anonymous — Thu, 19 Sep 2024 02:52:29 GMT

Can you imagine...

Re: Databricks ODBC driver error

Anonymous — Thu, 19 Sep 2024 07:53:47 GMT

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.

Re: Databricks ODBC driver error

SI_Eddy — Thu, 19 Sep 2024 07:57:29 GMT

This temp fix worked for me, thanks!

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

Re: Databricks ODBC driver error

trunks — Thu, 19 Sep 2024 11:26:35 GMT

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.

Re: Databricks ODBC driver error

itsme2003always — Thu, 19 Sep 2024 12:53:39 GMT

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