Reply
Highlighted
Frequent Visitor
Posts: 15
Registered: ‎01-19-2017
Accepted Solution

Refresh Cloud hosted MySQL Database

[ Edited ]

Hi, I have published a Power BI report, which points to a cloud based MySQL database hosted via AWS RDS.

 

To refresh the data I believe that a gateway is required. Is this correct?

 

It seems very peculiar that having built a serverless solution a server is now required for the single reason of facilitating a data refresh. If a gateway is required, are there any plans to change this so that all cloud based data sources are supported without the requirement of a gateway?

 

Thanks.


Accepted Solutions
Community Support Team
Posts: 2,956
Registered: ‎02-06-2018

Re: Refresh Cloud hosted MySQL Database

Hi @Agreenwood,



If I understand your scenario correctly that you connect the data from My SQL database which hosted on AWS RDS and you connect it with Amazon Redshift in Power BI Desktop?

 

If it is, I'm afraid that you may require a gateway to refresh the data.

 

Here is a similar thread you could refer to.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 2,956
Registered: ‎02-06-2018

Re: Refresh Cloud hosted MySQL Database

Hi @Agreenwood,



If I understand your scenario correctly that you connect the data from My SQL database which hosted on AWS RDS and you connect it with Amazon Redshift in Power BI Desktop?

 

If it is, I'm afraid that you may require a gateway to refresh the data.

 

Here is a similar thread you could refer to.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 15
Registered: ‎01-19-2017

Re: Refresh Cloud hosted MySQL Database

Hi,

 

That's correct - though the service is Aurora rather than RedShift.

 

I'm in a postition where I have a full serverless solution setup, though now I need to setup a server simply to refresh data from our cloud database to Power BI. This does seem very odd... is there an alternative way of facilitating a data refresh rather than setting up and maintaining a whole server? For example, perhaps this could be triggered through an API refresh? Or is there a third party application which may do the trick?