Forum Discussion

gabrielmorelli1's avatar
gabrielmorelli1
New Member
11 months ago
Solved

Refresh Error in Power BI Service – IDbCommand / ReadChunkWithRetries

 

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.

Need Help

9 Replies

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      10 months ago

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

    • mft_adm's avatar
      mft_adm
      New Member
      10 months ago

      Hi, Gabriel!

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

  • Gabry's avatar
    Gabry
    Super User
    11 months ago

    Hey,

    which data sources you’re using for these datasets?

  • tayloramy's avatar
    tayloramy
    Super User
    11 months ago

    Hi gabrielmorelli1, 

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

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    11 months ago

    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