cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!


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
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

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