Forum Discussion
unable to connect to Databricks; (ODBC error)
Hi MarinaK -The error you're encountering is related to SSL certificate validation when Power BI Desktop attempts to connect to Azure Databricks. By ensuring that the necessary driver files are present and accessible, checking network and firewall settings, updating drivers, and verifying SSL configurations, you can address the issue. If the problem persists, contacting Microsoft Support may be necessary for further assistance.
https://powerbi.microsoft.com/en-us/support/
Troubleshooting log files path:
Navigate to %localappdata%\Microsoft\Power BI Desktop\Tracing. share this information to msft
C:\Program Files (x86)\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Spark ODBC Driver\en-US\DSMessages.xml
C:\Program Files (x86)\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Spark ODBC Driver\DSMessages_en-US.xmlDownload the latest Simba Spark ODBC Driver directly from ODBC Drivers Download – Databricks or the official provider.Install the driver manually to ensure all necessary files are correctly placed.
Hope the above information helps.
Thank you for the response!
The IT department took it under investigiation, it turns out to be an issue in the firewall.
So if anybody else might run into a similar issue; maybe this can be of help.
