Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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"])
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.
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:
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
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?