Solved: Re: Refresh Now and Scheduled Refresh Not Working - Page 2

maracles · ‎07-18-2016

We have been using Power BI for several months now and have used Scheduled Refresh with very few issues. However the last week we have been experience increasing issues, and then today we cannot update at all.

The first issue we've been experiencing is as follows:

PowerBI would not refresh in the morning. Out last refresh at 11pm would work, but then nothing would refresh the following day unless we manually went in and click 'Refresh Now'. One we had done this the rest of the days scheduled refreshes worked as expected.

The second issue that we're are having as of today is as follows:

'Refresh Now' no longer runs. When I click it a notification appears for half a second saying that a refresh is happening and disappears, however the refresh does not complete. Usually there would be a loading indicator next to the dataset name - this is also not here.

Can anyone help troubleshoot these? Right now the only way of updating the data is me refreshing the POwer BI Desktop file and publishing. I do not want to be doing this manually 8x every day!

We only connect to one data source and that is our MySQL database, under credentials everything looks fine.

Thansks.

v-sihou-msft · ‎07-28-2016

@maracles

In this secnario, I suggest you check the logs first.

You can see On-premises data gateway service logs under:

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

And On-premises data gateway service event logs under Application and Services Logs.

Then please restart enterprise gateway service via command:

net stop PBIEgwService

net start PBIEgwService

If the issue still persists, I suggest you uninstall Enterprise gateway and install latest version On-premises data gateway. For more details, please see: Troubleshooting the On-Premises Data Gateway

Regards,

View solution in original post