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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
langer83
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
ankitpatira
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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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