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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors