Forum Discussion
Gateway Offline Error
I am continuing to receive the Gateway Offline error mesage on random days. Strangely, the all BI reports will refresh as expected daily and then the following day none will refresh due to Gateway Offline.
I checked the status of my company's gateway and they all state gateway is online.
Does anyone have any other suggestions? Perhaps I need to create a ticket with Microsoft?
Hi, IamTDR
This problem should occur in pbi service instead of report server, right? We need more information to judge.
How do you set up schedule refresh?
After receiving the error that the gateway is offline, all reports will not be refreshed, right?
Is your company's gateway open 24 hours?
Is your gateway updated to the latest version? Is it running normally?
Can you share the refresh history of the report?
Refresh summaries for Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Janey
I opened a ticket with Microsoft and I am awaiting to work with someone on this issue. Will report back if this issue gets resolved.
I am the admin for IamTDR company.
1. The error is showing in the PBI web interface, Everything on the gateway server looks fine2. 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.2. In regards to scheduling BI reports to refresh, this is done on the Power BI service. I schedule reports at different time points in attempt to prevent bottlenecks.
6. Refresh history has been shared to with Microsoft.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"?
