Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.