Issue with the refresh in the service

[kc_302]

The report is working and refreshing properly in the power bi desktop but in the service we are facing this issue.
"Cannot execute <ReadChunkWithRetries>b__0 after 5 tries. The exception was raised by the IDbCommand interface." 

[v-pnaroju-msft]

Hi kc_302,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi kc_302,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[tayloramy]

Hi @kc_302, 

I wanted to check in and see if you still needed help with anything? 
If not, could you please mark a post as the solution to close off this thread and help any other community members find the solution in the future? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.

[v-pnaroju-msft]

Thankyou @ibarrau, @tayloramy for your response.

Hi kc_302,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by @ibarrau, @tayloramy to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[tayloramy · Accepted solution]

Hi @kc_302, 
There's another thread about this same issue: Schedule refresh failed. - Microsoft Fabric Community

On that thread a CST posted this: 

This error happens because Power BI Service runs your refresh differently than Power BI Desktop. On Desktop, you’re connecting directly with your machine’s drivers, but in the Service, the refresh depends on either the cloud connector or the On-premises data gateway. This error message usually points to the Service struggling to read large chunks of data, either because of a gateway misconfiguration, invalid credentials or a query that pulls back too much data and times out when run in the Service. That’s why it works locally but fails when scheduled online.

To fix it, first make sure your dataset is mapped to the correct gateway in the Power BI Service and that credentials are valid under Dataset settings -> Data source credentials. If the gateway is fine, then look at query performance, apply filters in Power Query, enable query folding or reduce the size of data pulled back so the Service isn’t timing out. If you’re connecting to SQL, also check the command timeout in Power Query and increase it if needed.

Configure scheduled refresh - Power BI | Microsoft Learn

Install an on-premises data gateway | Microsoft Learn

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution

[ibarrau]

Hi. Make sure your dataset is mapped to the correct gateway in the Power BI Service and that credentials are valid under Dataset settings -> Data source credentials.

You can keep track of the issue in this post too that has the same problem. https://community.fabric.microsoft.com/t5/Service/Schedule-refresh-failed/m-p/4821250

I hope that helps,