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