Power BI Service Dataset not updating - MySQL database in Amazon

[ADC]

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.

[v-juanli-msft]

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