Forum Discussion
Limit exceeded error after refresh the report - Connected through Databricks.Query
ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Unable to continue fetch after reconnect. Retry limit exceeded.'..
The report data set connection is using Databricks.Query, I also added the EnableQueryResultDownload = "0" in the query. However still get an error.
6 Replies
- Expiscornovus
Most Valuable Professional
Hi Anonymous,
In the below thread it was suggested clearing the permissions on the data source might help.
https://community.fabric.microsoft.com/t5/Desktop/Databricks-Update/td-p/2817228
That might be worth a shot?
Hi Expiscornovus , thank you for you answer really appreciate that. I'm not sure this solution is for only when an error happens when refresh report on Power BI desktop or not. Because for my report it happens when I refresh the dashboard in PowerBI service (in the workspace on cloud)
- Expiscornovus
Yes, correct. In that thread it was happening in the Desktop client and not in the Power BI service, so this might not be applicable to your situation.
Just to double check, you are using this method to connect, correct?https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi#using-a-custom-sql-query
