Power BI Refresh Fails with "Unable to Continue Fetch After Reconnect" from Azure Databricks

Raj_DB
Contributor

a week ago

Hi everyone,

I'm refreshing a report with dataset (~10 million rows) from Azure Databricks in power Bi service. The refresh runs for about an hour and then fails with: Unable to continue fetch after reconnect. Retry limit exceeded. I am currently unable to determine if this issue originates in Power BI or Databricks. I have tested several potential solutions across both platforms without success. Upon reviewing the SQL warehouse query logs following the report failure, I observed the following error:

IMG_0222.jpeg

SQL warehouse current configuration:

Compute Type: Serverless

cluster size: Medium

I am getting the below error in Power bi service:

Data source error: {
"error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"parameters": {},
"details": [
{
"code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
"detail": {
"type": 1,
"value": "[Microsoft][Hardy] (35) Error from server: Unable to continue fetch after reconnect. Retry limit exceeded."}},
{"code": "DM_ErrorDetailNameCode_UnderlyingHResult",
"detail": {
"type": 1,
"value": "-2147467259"}}],
"exceptionCulprit": 1}}}

Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 4f41bd35-ef03-48a5-8b07-57c9b554f648
Request ID: 689cf96f-f8d7-c53e-b6d6-f4eb4e4c5d57

Has anyone experienced this issue or found a solution? Any suggestions would be appreciated.

Thank you!

Labels:
0 Kudos