Refresh Error in Power BI Service – IDbCommand / ReadChunkWithRetries

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