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
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.