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
maracles
Resolver II
Resolver II

Refresh Now and Scheduled Refresh Not Working

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.

 

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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

22 REPLIES 22

We have the same issue with SQL Database Data Sources. The Refresh Now button is not working. This seems like a Microsft side issue... 

@v-sihou-msft Thank you for the suggestion. This actually seemed to resolve itself however what you recommend is useful to now in future.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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