Forum Discussion

ADC's avatar
ADC
Frequent Visitor
7 years ago

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...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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