Forum Discussion

anmolmalviya05's avatar
anmolmalviya05
Super User
1 year ago
Solved

Power BI Report refresh error

Is anyone getting below error while refreshing reports on Services: Data source error{"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","pbi.error":{"code":"DM_GW...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    That is standard behavior when your capacity admin has set query timeouts.

     

    You can assume that in general the service is strict when it comes to enforcing timeouts, while the desktop relies on the data sources to enforce that.

  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi anmolmalviya05 ,

    Thank you lbendlin  for your response.
    You are right, this error also occurs due to query timeouts.
    Models hosted on Power BI Pro have a refresh time limit of two hours.
    This time limit applies to the duration allowed for refreshing the data and updating the model with the latest information. While sufficient for many scenarios, this time constraint may pose limitations for larger datasets or more frequent refresh requirements
    Models hosted on Premium capacities enjoy a more generous refresh time limit of five hours. Premium capacities offer enhanced performance and scalability, allowing for larger datasets and more complex refresh operations.

     

    I just wanted to follow up and check if the issue has been successfully resolved or if you still need further assistance. If you have any remaining questions or require additional support, please don't hesitate to reach out, I’ll be more than happy to assist you further.

    Thank you again for your patience, and I look forward to your response.

    Best regards,
    Chaithra E.



v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi anmolmalviya05 ,

The error DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError indicates a query timeout via the On-premises Data Gateway in Power BI Service. While Power BI Pro allows up to 2 hours for refresh, timeouts can still occur due to:
Large datasets, inefficient queries, or network/gateway issues
Firewall restrictions or HTTPS mode enabled in the gateway, try disabling it.
Resource bottlenecks (CPU/memory) on the gateway or data source server.

Try these troubleshooting steps:

Check gateway logs and firewall settings
Ensure HTTPS mode is off in the gateway app
Update the gateway and verify it's running smoothly
Run the query directly on the source to test performance
Optimize data model and enable incremental refresh if possible
Increase timeout settings in both PBIX and gateway config
Schedule refreshes during off-peak hours.

Hope this helps.
Best Regards,
Chaithra E.