Forum Discussion
Refresh Cloud hosted MySQL Database
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.
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
7 Replies
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
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?
Agreenwood have you had any success?
I am in a similar situation as you. I have a fully serverless setup with data source being MariaDB on AWS, but cannot refresh the dataset without a Gateway. It is confusing and strange to say the least.
