Limit exceeded error after refresh the report - Connected through Databricks.Query

[Sukritta]

There is on report that I faced this error almost everyday after the refresh get triggered.

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.

[Sukritta]

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

[Sukritta]

Correct I use the custom  sql query one.

[Expiscornovus]

And you used the import mode in the connection, correct?

Which type of authentication are you using for that setup? (PAT, Entra Id or Username/password)

[Sukritta]

yes I use import mode.

 I use the third one for authetication.

[Expiscornovus]

Hi @Sukritta,

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?