Refresh Error in Power BI Service – IDbCommand / ReadChunkWithRetries

[gabrielmorelli1]

Hello everyone,

I have several datasets published in the Power BI Service, scheduled to refresh daily at 7:00 AM. Everything was working fine until last Friday, when some refreshes started to fail.

Context:

• Account used: corporate account (Power BI Pro license).

• Scheduled time: 07:00 (all datasets).

• The error occurs in different datasets, but each one fails on a different table.

• If I republish the PBIX file, the refresh works at first. However, when I try to refresh again in the Service, the error returns.

• Important: in Power BI Desktop, refresh works normally without errors.

What I have already checked:

• Verified that the service account used to connect to the database is properly configured both in Power BI Desktop and Power BI Service.

• The connection/credentials are fine: in Desktop I can refresh and pull the data normally.

• In Power BI Online (Service), the tables fail with the refresh error.

• I tested different queries, including from other databases and other tables, and the same error occurs.

• Even when trying to refresh manually in the Service, the error still happens.

• The only workaround so far is: refresh the dataset in Desktop, delete the one with the error in the Service, and publish it again.

Data source error: Cannot execute <ReadChunkWithRetries>b__0 after 5 tries. The exception was raised by the IDbCommand interface. Table: ancora_deposito.

My question:
I would like to understand what could be causing this error in the Power BI Service, since in Desktop the datasets refresh normally. Is there any limitation or specific configuration in the Pro plan (such as concurrency or shared capacity) that could be causing this failure?

Thank you in advance for any guidance.

[V-yubandi-msft]

Hi @gabrielmorelli1 ,
Has your issue been resolved, or do you need more information?

[V-yubandi-msft]

Hi @gabrielmorelli1 ,

When you have a moment, please let us know if everything is okay on your end or if you need any further assistance.

Thank you.

[gabrielmorelli1 · Accepted solution]

https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-BigQuery-connector-failing-with/t...

[mft_adm]

Hi, Gabriel!

This worked for us here at MFT. Thanks a lot!

[V-yubandi-msft]

Thanks for your conformation.

[V-yubandi-msft]

You mentioned a workaround in the link you shared. Can you confirm whether it worked for you?

[V-yubandi-msft]

Hi @gabrielmorelli1 ,

Thanks for posting your query in the Microsoft Fabric Community. When you refresh data in Power BI Desktop, it runs locally and isn't affected by service level limits. However, in Power BI Service especially on shared capacity with a Pro license you might encounter issues due to factors like too many concurrent refreshes, limited resources, or long running queries. This is more likely if several datasets are scheduled to refresh simultaneously.

If you see an error about ReadChunkWithRetries and IDbCommand, it usually means the Service is having trouble processing the query under heavy load.

Few ideas to resolve this, 

1. Adjust your refresh schedules so they don't overlap.
2. Check that your gateway setup is working properly and isn't overloaded.
3. Test publishing to a Premium trial workspace to see if dedicated resources improve refresh performance.
4. Simplify your queries to reduce the load during refresh.

As the issue continues, could you provide additional information about your setup? Details like the data source type, whether a gateway is being used, and any relevant configurations would be helpful.

Regards,
Yugandhar CST_Team

[tayloramy]

Hi @gabrielmorelli1, 

In addition to Gabry's question about what datasoruces are being used, are the datasources using an on prem data gateway?  

[Gabry]

Hey,

which data sources you’re using for these datasets?