Forum Discussion

prithasarkar01's avatar
prithasarkar01
New Member
5 months ago
Solved

OLE DB / ODBC Error (HY000) – Cannot enable SSL while downloading result file from cloud store

Hello everyone,

I am facing an issue while refreshing/loading data in Power BI Desktop. The report fails to load and shows the following error message:

Data source is Azure Data bricks

 

 

 

 

Environment:
• Power BI Desktop
• Connection involves multiple datasets 


• Data is being retrieved from a cloud-backed source
• Corporate environment

Troubleshooting already attempted:
• Restarted Power BI Desktop
• Cleared Data Source permissions
• Tried refreshing again
• Contacted Service Desk, but they were unable to resolve the issue

Because of this error, the dataset cannot be refreshed and the report cannot retrieve the required data.

Has anyone experienced a similar issue or knows if this is related to SSL configuration, ODBC driver settings, or server-side configuration?

Any guidance would be greatly appreciated.

 

Thanks,

Pritha 

Need Help
  • Juan-Power-bi's avatar
    Juan-Power-bi
    5 months ago

    Hi Pritha! This error with Databricks is almost always caused by a corporate proxy doing SSL inspection, which breaks the certificate chain when the ODBC driver tries to stream results through Azure Blob Storage.
    Two things to try:
    Quickest fix — disable cloud fetch in your Databricks ODBC connection settings by adding UseNativeQuery=0 and EnableArrow=0. This bypasses the blob storage step entirely and usually resolves it immediately.
    If that doesn't work — ask your network team to whitelist *.blob.core.windows.net from SSL inspection, or at minimum confirm whether the proxy is intercepting that traffic.
    Also worth checking: make sure you're on the latest Databricks ODBC driver, as older versions have known SSL issues that were fixed in newer releases.

3 Replies

  • Juan-Power-bi's avatar
    Juan-Power-bi
    Super User
    5 months ago

    Hi Pritha! This error with Databricks is almost always caused by a corporate proxy doing SSL inspection, which breaks the certificate chain when the ODBC driver tries to stream results through Azure Blob Storage.
    Two things to try:
    Quickest fix — disable cloud fetch in your Databricks ODBC connection settings by adding UseNativeQuery=0 and EnableArrow=0. This bypasses the blob storage step entirely and usually resolves it immediately.
    If that doesn't work — ask your network team to whitelist *.blob.core.windows.net from SSL inspection, or at minimum confirm whether the proxy is intercepting that traffic.
    Also worth checking: make sure you're on the latest Databricks ODBC driver, as older versions have known SSL issues that were fixed in newer releases.

  • v-achippa's avatar
    v-achippa
    Community Support
    5 months ago

    Hi prithasarkar01,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Juan-Power-bi for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      5 months ago

      Hi @prithasarkar01,

       

      We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa