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.

[sduffy]

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

[The_Bishop]

Thanks. Done.

[nawhiteley]

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

[sduffy]

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. 

[The_Bishop]

Yes, our refreshes are OK, too. Thankfully.

[Anonymous]

Can you imagine...

[Amberr567]

This is my exact experience

[Amberr567]

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.

[dharmendars007]

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

LinkedIN 

[The_Bishop]

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.