Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MJEnnis
Helper V
Helper V

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 2
3CloudThomas
Super User
Super User

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.

Thank you @3CloudThomas! 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! 🙂 )

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.