Showing results for 
Search instead for 
Did you mean: 
Level 8

On-Premises data gateway for Microsoft Flow_ SQL 2016

Hi all,


I am looking into an on-premice data gateway to connect to some SQL DB's that I have.


when reading the guides I am only seeing a connection reference to SQL 2016.


can any one tell me that if I do get IT to create a gateway for me will I then be able to access any earlier version of SQL 2016 such as SQL 2014 via Flow?





Community Support Team
Community Support Team

Re: On-Premises data gateway for Microsoft Flow_ SQL 2016

Hi Lee,


You could try to install and configure on-premises data gateways following the steps in this documentation:


Then you could connect to your on-premises data sources from Flow using on-premises gateway, please refer to this documentation:


If you are using PowerApps, you could also create a connection to on-premises SQL Server according to this documentation:


Please try it on your side and let me know if you need more help.



Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level 8

Re: On-Premises data gateway for Microsoft Flow_ SQL 2016

Hiya, thanks for getting back to me on this.


my main query is if I can connect to a SQL 2014 DB or will I only be able to connect to SQL Server 2016?


many thanks for your help and guidance so far



Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,089)