Databricks import error - retry limit to download from cloud store

[Anonymous]

I am using version: 2.100.1401 - Power BI desktop

Tried to load a delta table in 'Import' mode from Databricks. The below error occurs everytime we try to load- 'apply' the changes.

Table is small to medium with 350K records and 40 columns.

Any help is really appreciated. 

[MadisZ]

Clearing the permissions in the data source settings in most cases helps to resolve this issue.

[deepu299]

For anyone who is facing this error, try adding EnableQueryResultDownload="0" to the source, something like this: 

*******, [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null,EnableQueryResultDownload="0"])

[Anonymous]

I am using version: 2.100.1401 - Power BI desktop

Tried to load a delta table in 'Import' mode from Databricks. The below error occurs everytime we try to load- 'apply' the changes.

Table is small to medium with 350K records and 40 columns.

Any help is really appreciated. 

[v-angzheng-msft]

Hi, @Anonymous 

Try connecting the Databricks to direct query mode and check if the issue goes away.
Here are some reference documents for connecting Databricks:

Power BI

Databricks partners

JDBC\ODBC connection to Azure Dataricks fails

If the above resources don't help, in these types of errors our suggestion would be to raise a Support Request with Microsoft, so we can perform a more in depth Troubleshooting to understand exactly what is going on with the issue you are currently facing.

If you have a Pro account it is free. Go to https://support.powerbi.com

Scroll down and click "CREATE SUPPORT TICKET".

Best Regards,
Community Support Team _ Zeon Zheng

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

[Anonymous]

I tried with the databricks.query option - entered select * from schema_name.table_name  and receive the same error.

Is there some limitation on number of rows and columns that can be retrieved?