Power BI Gateway on Remote Desktop Fails Daily

Question

Trying to install a standard gateway on a Remote Desktop. The gateway works for about 24 hours and then fails. Once I login to the "On Premise Gateway" app, and restart the gateway it works again for another 24 hours.

The error message the incremental refresh shows is either "DM_GWPipeline_Gateway_SpooledOperationMissing" or "DM_GWPipeline_Gateway_TimeoutError"

Any help would be greatly appreciated!! Thank you!

I have tried restarting the gateway and running the check network check to make sure reaching the ports is successful.

Answer 1

After a failure log onto the Remote Desktop machine and open Task Manager from the start menu. Go to the Performance tab and then the CPU tab. Note the Uptime metric. If that uptime is just a few minutes then this machine is not “always on”. This is typical for many virtual desktop machines which pause after a period of not being logged into.

As stated in the documentation:

Don't install a gateway on a computer, like a laptop, that might be turned off, asleep, or disconnected from the internet. The gateway can't run under any of those circumstances.