Forum Discussion
Azure Databricks - Refresh Error
Hi nirupamroy It is likely because of certificate validation or outdated Simba ODBC drivers. Ensure the certificate chain is valid and accessible, update the Simba Spark ODBC driver to the latest version, and verify no network blockages affect CRL access. Temporarily disable SSL revocation checks in the ODBC driver settings for testing. If issues persist, refresh cached metadata in Power BI and reconfigure the data connection.
Yes, the issue finally got resolved. After extensive brainstorming and multiple back-and-forth conversations with the local IT team at the office, we identified that the root cause was Zscaler, a cloud-based security platform that had been installed a few weeks ago. Its SSL inspection feature was interfering with the connection between Azure Databricks and Power BI. We resolved the issue by disabling SSL inspection for the API that pulls data from Azure Databricks (Azure Blob inspection bypass) and installing the Zscaler root CA certificates for Databricks Connect, which we also configured for Power BI.
Community SupportHi nirupamroy,
We sincerely appreciate your inquiry via the Microsoft Fabric Community Forum.
From my understanding, the error you are encountering arises due to a certificate chain validation failure while attempting to download result files from Azure Databricks. This issue generally occurs when the SSL certificate is incomplete or untrusted, the Certificate Revocation List (CRL) or Online Certificate Status Protocol (OCSP) checks fail due to being unreachable, or if the ODBC driver files are missing or corrupted.
Kindly follow the steps outlined below, which may help to resolve the issue:
- Update the Simba Spark ODBC Driver by installing the latest version to address connectivity and SSL-related issues.
- Verify the certificate chain by accessing Databricks in a web browser. Click on the lock icon and ensure that no certificates are missing or untrusted.
- Ensure that your network or proxy allows outbound access to certificate validation endpoints (such as ocsp.* and crl.*).
- Reinstall the driver if the DSMessages.xml file is missing or corrupted.
- In the ODBC settings, add the parameter CheckCertRevocation=0 under advanced options. Please use this only for troubleshooting purposes and not in a production environment.
- Delete and reconfigure the Databricks connection in Power BI Desktop, and then re-enter your credentials.
Additionally, please refer to the following links for more information:
Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn
Program Requirements - Microsoft Trusted Root Program | Microsoft Learn
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Should you have any further questions, please feel free to contact the Microsoft Fabric Community.
Thank you.