Forum Discussion

MJEnnis's avatar
MJEnnis
Icon for Resolver III rankResolver III
2 years ago

On Premises Gateway on Virtual Machine (Automatic Refreshes Failing)

My ICT department recently set up a virtual machine so that I can schedule refreshes to occur when I am not working and my work computer is turned off. I have successfully installed PowerBI Desktop on the VM and saved all PBI files there. I have deployed the on premises gateway, shared the reports via the PowerBI Service, and worked through a few bugs (e.g., changing privacy level to "organizational" for semantic models) so that reports can be manually refreshed. So far so good...

 

However, there is a problem with automatic refreshes. If I am connected to the VM via Remote Desktop, or if I have been recently connected, automatic refreshes work just fine. However, if I have not been disconnected for a a couple hours, the refreshes fail and I receive the following error message: 

"Failure details: The last refresh attempt failed. Your Personal Gateway is offline or could not be reached. Ensure the Gateway computer is on and you are logged on to it during the scheduled refresh period."

 

It seems that the VM is going to sleep. I have changed the display and power settings on the VM so that display and hard disk should never turn off. But after some time of being disconnected, I always have to login again. Is there something I have to do on my end to keep the VM on at all times, or does ICT have to do something to the settings on the server or something? Thanks!!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You need to use the Enterprise Gateway, not the personal gateway

    Power BI Gateway | Microsoft Power BI

    Go to Download Standard Mode, not personal

    Also, you are best using a service account, not your personal account. Have your security group create an Entra Account with permissions to the data source.

    • MJEnnis's avatar
      MJEnnis
      Icon for Resolver III rankResolver III

      Thank you Anonymous! I will try the standard gateway option. But how is it possible that the manual refreshes work but not the scheduled refreshes if it is an issue with the gateway? From the documentation, I can not understand how this could be the issue. (Note that I am not an IT guy! 🙂 )