cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

mysql scheduled refresh from enterprise gateway never runs

I have an enterprise gateway setup on a seperate server with a mysql database used for a report in power bi online. I can manually refresh the dataset but when I schedule a refresh, the refresh never runs and I receive no email notification regarding a failure.

 

The gateway status is online and the service is running on the server with the mysql database.

The user has been setup for the datasource in the gateway and the connection is successful when tested.

 

Anyone have any ideas as to why?

 

 

UPDATE:  The first scheduled refresh just ran... I scheduled it for 9:00am and it ran at 9:14am?? The user was changed to be able to manage the enterprise the gateway around this time. Is that necessary to be able to schedule refreshes?

 

 

2 REPLIES 2
Community Champion
Community Champion

@langer83 it is said officially that when you setup schedule refresh it may take upto 1 hour for it to trigger. having said that i have always seen schedule refresh starting in 15 mins time frame of the actual schedule.

 

The scheduled refresh started working now but is about 2 hrs+ late. The last 3 refreshes were scheduled for 11:30am.refresh.JPG

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors