cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpc_development Regular Visitor
Regular Visitor

MySQL Dataset does not refresh on PowerBI App

EDIT

 

The simple way to ask the below original post is: Is it possible to publish a Power BI Desktop created report, which connects to Amazon AWS RDS, and then refresh it going forward from the Web App?

 

-----END EDIT-----

 

 

We have a MySQL database hosted on Amazon AWS RDS, and it is public (no SSH).

 

I created a report using Power BI Desktop and then published it to the web app. While it refreshes data when refreshed through Power BI Desktop, the web app does nothing when I click on the Refresh button from the published report.

 

It is possible to refresh a MySQL database directly from the web app, without Power BI Desktop?

 

I read something about installing a gateway, but my datasource is on the cloud.

2 REPLIES 2
Community Support Team
Community Support Team

Re: MySQL Dataset does not refresh on PowerBI App

Hi @dpc_development ,

 

As I know an App in power bi will not be updated automaticly if the content of the workspace has been updated. You should update it manually. If you mean the report, you can set schedule refresh of the dataset to get the new data. Please refer to the online document about Configuring scheduled refresh. Also the gateway is required here. You can download the on-premise gateway to have a try.

 

Regards,

Frank

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

Re: MySQL Dataset does not refresh on PowerBI App

@v-frfei-msft That is my problem, my database is a MySQL DB running in a managed AWS RDS instance. I will not be able to install the gateway in the server where my database resides, as I don't manage that.

 

I am not sure why a gateway is required in my case though, as my database end point is on a fixed public ip, never changes, is on the cloud, not on-premise, and accessible without SSH / SSL.

 

 

Does this mean, my only option is to refresh MySQL in Power BI and publish for the others? That'd be really inefficient while even 3rd party web apps such as DOMO are capable of this.

 

 

I also tried connecting Power BI to an AWS SQL Server instance using Direct Query, and even that requires a gateway while the end point is online in the cloud and it being a Microsoft product.