Forum Discussion
Power BI Service Dataset not updating - MySQL database in Amazon
Hi all,
I need to prepare a Dashboard in Power BI service that can be automatically refreshed, but currently I can only refresh it if I use the desktop version, refresh and publish.
The DB is a MySQL database hosted in Amazon.
I have never done this. Should I take something into account?
Thanks in advance for your help.
1 Reply
Hi ADC
Do you connect with import mode or direct query/live connection?
First please read this article about refresh in power bi service and pay attention to schedule refresh
https://docs.microsoft.com/en-us/power-bi/refresh-data#what-can-be-refreshed
your dataset could refresh at once by clicking on "refresh now" button or refresh on schedule by configuring schedule refresh.
It needs gateway for either automatically refresh or scedule refresh in your scenario.
Please follow the steps below
how to configure schedule refresh automatically in power bi service.
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
Install gateway
https://docs.microsoft.com/en-us/power-bi/service-gateway-install
Manage gateway
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
Connect datasource to gateway
https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-scheduled-refresh
Best Regards
Maggie
