I have installed the Personal Gateway so I can refresh a dataset on a SQL database automatically. When I enable Scheduled refresh, it will not stay on. These are the steps I follow:
Why is it turning off, and how can I get it to stay on? The personal gateway status says "online, running." It is installed on a machine that is always on and has an Ethernet connection.
This keeps happening to me - almost every 3 days now. Since the schedule switches to off, I receive no notification that refresh failed so it takes a team member to email me that data is behind. Turn it on, it stays for a couple days. I have the new gateway so not that.
This same thing happens to us... We have tried different accounts to schedule the refresh, different browsers... Regardless, similar to what was mentioned above, the On-Premise gateway will randomly switch off the schedule and the schedule will be stopped.
The gateway that we are using is installed on a server, so it should remain always on.
I too, have this issue and have not found a solution. It makes me look bad when my boss' dashboard is out of date, and it is not a viable solution to update all of my datasets manually everyday.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.