cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seps Frequent Visitor
Frequent Visitor

MySQL Dataset Refresh without Gateway

My data are located on a public MySQL server.

Is there a way to enable direct data refresh, without using a Gateway, in the same way as I do for other data located on AWS Redshift ?

If not, what is the technical reason behind ?

3 REPLIES 3
seps Frequent Visitor
Frequent Visitor

Dataset Refresh without Gateway to MySQL Server

My data are located on a public MySQL server.

Is there a way to enable direct data refresh, without using a Gateway, in the same way as I do for other data located on AWS Redshift ?

Super User
Super User

Re: MySQL Dataset Refresh without Gateway

I suspect that the technical reason behind it is that the service-based gateway does not support MySQL as MySQL is likely presumed to be local or not cloud accessible. For data sources that are presumed to be cloud accessible directly, those are supported by the service such as web pages, OData sources, Azure SQL DB, etc.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
seps Frequent Visitor
Frequent Visitor

Re: MySQL Dataset Refresh without Gateway

Maybe SQL server were not initally supposed to be "cloud accessible" but it is technically feasible.

The best example is that other BI solutions such as Tableau do offer this functionnality.

I am currently designing my system and I would need to know if this feature is offered or is on the roadmap, to choose the appropriate tools.

Thank you for your feedback

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 107 members 1,594 guests
Please welcome our newest community members: