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.