Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual


I would like to pull data out of my on premise MySQL database and use in Dynamics 365 and other PowerApps.  Even though I have access to the MySQL, my company probably has firewalls, and other things that make having Flow get to it very hard.  I may be able to use a gateway on a VM maybe to do this?  But my tests don't seem to be working, "test connection failed" is all I get.


But maybe there's a better way?


What is the best way to get data out of (and potentially some day into) MySQL on premise to use in flows, dynamics, etc.




Dual Super User
Dual Super User



I agree, troubleshooting network firewalls is not easy task.


Here are the gateway trouble shooting help:


Please see if any of them is helpful.




If my reply helps, please mark it as Accepted Solution. So that, other users can find it helpful instead of re-posting same question.

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Kudoed Authors
Users online (12,340)