Forum Discussion
Gateway Offline Error
I am the admin for IamTDR company.
1. The error is showing in the PBI web interface, Everything on the gateway server looks fine
2. IamTDR will need to confirm, but I believe the refresh is scheduled in powerbi somehow.
3. Some reports refresh while others fail within the same timeframe.
4. The gateway is closed overnight but these refreshes are not occuring during that down time.
5. The gateway is on the latest version
6. IamTDR will need to provide those
Initially, the MS tech was looking at the network ports test on the gateway where like 6 of the 23 ports were failing for some unknown reason (we do not block outgoing ports on the firewall, and the ports that failed changed on each test). I disabled HTTPS mode and now all ports are reporting as open.
My suspicion is that the gateway (or the DB it connects to) is getting overwhelmed at times. I do see CPU spikes nearing 100% on the gateway while refreshes are running, but I can't find an exact coorelation as it does this when refreshes work as well. The DB server resources do not seem to be abnormally taxed.
If there are multiple refreshes in the same time period, some reports may fail to refresh.
You can check the document to understand:how-capacities-function
Issues in this aspect really need to be further understood and eliminated before they can be judged. I'm glad your problems can be found and solved by Microsoft.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Sorry, I should have been more clear. All the reports do not run at the same time. There are multiple reports spread out over a 4 hour window. But report A runs at the same time every day. Report B runs at a different time from report A but at the same time every day. Though I do think it is likely some of these reports are overlapping and it is a capacity issue. That said, wouldn't that throw an error other than "gateway not available"?
bmaull The refresh time set may not refresh on time, and there may be a delay.
Sorry, I don’t know the progress between you and Microsoft support.
Has the problem not been solved yet?
What's the situation now? Can you provide a screenshot of the error?Janey
Above is a image of the type of error we were receiving as of 9/30/21. For the last two days, reports have refreshed on schedule as expected.
