Unable to import all records from Azure Databricks

[powermbz]

Hi folks,

I am trying to connect to Azure Databricks workspace from PowerBI desktop from my local machine and I am facing an error. I am not able to load all the rows, if I limit to certain rows it is working fine. It is throwing below error.

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File 3015594c-55ed-452c-b551-1130d99fc48c: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded

But when I try to access the same data from PowerBI desktop installed in a Azure VM it is working fine and able to retrieve all the records. 

Any leads on solving this error would be of great help. Thanks

[v-tangjie-msft]

Hi @powermbz ,

Here are a few steps you can take to troubleshoot and potentially resolve this issue:

1. Check Network Configuration: Ensure that your local machine's network configuration does not restrict or limit connections to Azure services. This includes checking any firewall settings or network policies that might be in place.

2. Increase Timeout Settings: Try increasing the timeout settings in Power BI Desktop when connecting to Azure Databricks. This can sometimes help with issues related to network latency or large data transfers.

3. Optimize Data Model: If the dataset is very large, consider optimizing your data model or limiting the amount of data you're importing into Power BI Desktop. This can be done by filtering the data in the query editor or summarizing the data in Azure Databricks before importing.

4. Ensure that the version of Power BI Desktop on the local computer matches the version in the VM.

5. Documentation and Guides: For more detailed guidance on connecting to Azure Databricks from Power BI and troubleshooting common issues, I recommend reviewing the following documentation:

Azure Databricks Power Query connector - Power Query | Microsoft Learn

Azure Databricks connector overview - Microsoft Fabric | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.