OLE DB or ODBC error: [DataSource.Error] ERROR [HY000]

[bugsysiegals]

I receive the following error when trying to load anything bigger than "small" data from Azure Databricks. 

OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File 1679c254-86f6-4290-9a80-19febd6cb4a4: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File 1679c254-86f6-4290-9a80-19febd6cb4a4: An error had occurred while attempting to download the result file.The error is: Couldn't connect to server. Since the connection has been configured to consider all result file download as retriable errors, we will attempt to retry the download.'..

I’ve noticed the following …

• I can load small tables but anything large will always produce this error.
• I can open Power BI on my PC with any of my colleagues domain accounts (run as another user) and the data refreshes.
• I can open Power BI on my colleagues PC using my domain account (run as another user) and the data refreshes.

This error is specifically tied to my account on my PC alone.  I don’t recall if this got this way after installing ODAC or something else but clearly something is messed up with my account on my PC.  I’ve uninstalled ODAC, uninstalled/reinstalled PBI, and reinstalled the Simba Spark driver all without any success.

I do not want to reformat my PC … is there some log file to better understand what’s wrong so this can be fixed?

[rajendraongole1]

Hi @bugsysiegals - 

Ensure your PC is not blocking Power BI or Azure Databricks-related traffic.
Test your connection to Azure Databricks using tools like ping or tracert to ensure network reachability.
2. Clear Power BI Cache
Power BI caches data locally, which might cause issues.
Go to File > Options and Settings > Options > Data Load and clear the cache.
3. Inspect ODBC Driver Settings
Check the Simba Spark ODBC driver configuration.
Open the ODBC Data Source Administrator on your PC.
Verify the settings for the Azure Databricks DSN, including the server hostname, HTTP path, and authentication credentials.
4. Check Power BI Logs
Power BI maintains diagnostic logs that can provide more detailed insights.

Enable tracing by going to File > Options and Settings > Options > Diagnostics and turning on "Enable tracing."

C:\Users\<YourUsername>\AppData\Local\Microsoft\Power BI Desktop\Traces

Ensure you are using the latest version of the Simba Spark ODBC driver provided by Databricks.

Uninstall the existing driver, restart your PC, and reinstall it from the official Databricks website. (Remove and reconfigure ODAC again).

Hope the above details helps.