Forum Discussion

nirupamroy's avatar
nirupamroy
Frequent Visitor
1 year ago
Solved

Azure Databricks - Refresh Error

Hi   Need your help. Facing a strange issue while updating power bi dashboard connected to Azure Databricks while refreshing dataset. The dashboard was working absolutely find and was getting updat...
data protection
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

  • nirupamroy's avatar
    nirupamroy
    1 year ago

    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.

burakkaragoz's avatar
burakkaragoz
Icon for Super User rankSuper User
1 year ago

Hi nirupamroy ,


This error is related to SSL/TLS certificate validation when Power BI tries to refresh data from Azure Databricks. It usually means that Power BI cannot validate the certificate presented by Databricks—either due to missing or untrusted root certificates, network restrictions, or an incomplete certificate chain.

Here are some recommended steps to resolve this issue:

  1. Validate the Certificate Chain:
    Ensure that the SSL/TLS certificate used by your Databricks cluster is valid, not expired, and signed by a trusted authority. If the certificate was recently changed or updated, make sure all intermediates and root certificates are also valid.

  2. Update Root Certificates:
    On your Power BI machine, update the Windows root certificates. You can do this via Windows Update, or by downloading and installing the latest root CA certificates.

  3. Check Network Access for Certificate Validation:
    Certificate validation requires the ability to reach certificate revocation lists (CRL) or OCSP endpoints. Make sure your network, proxy, or firewall does not block access to these URLs. If your organization restricts outbound traffic, you may need to allowlist URLs related to the certificate authority.

  4. Update the ODBC Driver:
    Ensure you are using the latest Microsoft Spark ODBC driver for Power BI. Newer drivers often resolve certificate and connectivity issues.

  5. Restart Power BI and Your Machine:
    After performing these steps, restart both Power BI Desktop and your computer to ensure the new settings and certificates take effect.

If the issue persists after these steps, contact your IT team to review certificate trust settings or open a ticket with Microsoft Support for further assistance.

Let me know if you need detailed instructions on any of the steps above!
translation and formatting supported by AI