Refresh AWS RDS database from Power BI Service

[manaryo93]

I have my Power bi desktop which is connected to AWS RDS database

I installed mysql connector and it refreshes fine in desktop

However, when I published the report to Power Bi Service , the automated refresh didnt work

How to solve this issue? 

[v-yangliu-msft · Accepted solution]

Hi  @manaryo93 ,

To refresh data in the Power BI service, you also need to configure the gateway to set the schedule for refresh.

Data refresh in Power BI - Power BI | Microsoft Docs

Configure scheduled refresh - Power BI | Microsoft Docs

On-premises data gateway - Power BI | Microsoft Docs

In Power BI Service, you can set schedule refresh for your dataset, in order to set how often it refresh your dataset, you would need to configure on-premises gateway and add Amazon AWS data source under the gateway. For more details, you can review this article.

There is also a similar thread for your reference: 

Power BI and SQL Server in the AWS - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.