Power BI Data Gateway Stopped working

[gautampruthi]

Hi, 

We have been using Data Gateway to update  on premise date in Power Bi Dashboard. In april the scheduled refresh stopped working as part of troubleshooting we updated the gateway and the issue resolved the same issue took place again and we managed to resolve this by updating the gateway. 

How can we mitigate this issue or whats the reason behind it

[DallasBaba · Accepted solution]

@gautampruthi This is related to updating servers. Microsoft is releasing monthly updates that require you to log in to the system in which the gateway is installed and reboot your gateway server periodically because they are now getting updated monthly.

The machines update on the second, third, and fourth Saturdays of the month, beginning at 11 PM, and have a 4-hour update window. The idea is to phase in updates to catch any bad updates before they get deployed to a critical server.

Helpful Resource

• Monthly updates to the on-premises data gateways,   Power BI Gateways–March Update 

Accept as a solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

[gautampruthi]

Hi @lbendlin 
The scheduled refresh stopped itself and then when we checked the datails were "

Failure details: Your data gateway is offline or could not be reached. Ensure the computer running the gateway is on during the refresh period."

The system in which gateway is installed remains on everytime.

The gateway version is 3000.222.5 and the gateway is installed in only one machine with no proxy involved.

Do you think adding cluster member can help in mitigating this?

[lbendlin]

Are you using a personal gateway?

[gautampruthi]

yes, its a personal gateway

[lbendlin]

Personal gateways are implemented as Windows applications. They need to be open when you are attempting a refresh  (which means that the PC they are running on must be on and working during that time too).

[lbendlin]

the scheduled refresh stopped working

Please provide more details.  Was the schedule suspended due to four consecutive refresh failures?  Did it switch off by itself?

How many gateway cluster members? Which gateway version?  Is a proxy involved?