Forum Discussion
Refresh AWS RDS database from Power BI Service
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?
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.
1 Reply
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.