Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
2 years ago

Timeout on Auto refresh

Hello We have serveral Power BI reports on the Power BI Service that are shared, they auto refresh every day, however most days the timeout, with this error; {"error":{"code":"DM_GWPipeline_Gateway...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi GrahamR99 

Please try to put the report in a different refresh schedule time like the example below
1. One large dataset report, kept at 7.00 am
2. Two medium dataset reports at 7.30 am

Dont keep all reports in same time slot
Check your report performance issue and optimize your report
Search Google for "how to optimize power BI reports" and learn


GrahamR99's avatar
GrahamR99
Resolver I
2 years ago

Hello PijushRoy  

I have already tried different times, and that didn't work.  I have 7 reports auto refreshing 5 refreshes at 7:30am, one at 8am and one at 8:30am the two that run after 8 are the ones failing.

 

Is there no better solution than the time it runs, our organisation is planning to increase the amount of Power BI reports massively and if it can handle two reports now what's it going to be like in the future?

 

These reports that fail are not large datasets either, they are 500MB at most at a guess, still trying to work that out, but need Microsoft Fabric to work out and we don't have that yet.

 

Is there anything better you can suggest?

 

Regards

GrahamR99

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I have the same here. Dataset has 500mb. Sometimes the refresh works, sometimes it doesn't. 

    Sometimes takes 1 hour, and sometimes 2 hours. 

    It's really hard to track where the bottleneck is.