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.
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:
The second issue that we're are having as of today is as follows:
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.
Solved! Go to Solution.
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.