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 SupportThank you, burakkaragoz and Akash_Varuna for your response.
Hi nirupamroy,
We would like to check if the solution provided by burakkaragoz , Akash_Varuna has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.
Thank you.
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.
- v-pnaroju-msft
Hi nirupamroy,
Thank you for sharing your insights and approach in resolving the issue.
We kindly request you to mark your response as the accepted solution, as this will help other community members find answers to similar challenges more efficiently.
Please continue leveraging the Fabric Community for any further assistance with your queries.
Thank you.