Forum Discussion
Databricks ODBC driver error
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.
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.
30 Replies
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.
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.
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
Thanks. Done.
Going back to the July version has got me working again for now.
It worked for me after moving to the July version. Thanks.
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.
Yes, our refreshes are OK, too. Thankfully.
This is my exact experience
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.
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 issueThe latest release from the MS Store (19/09/20/24) sorts this.
Still broken for me, and not update button.
Will stick with July for now
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
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.
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.
