Showing results for 
Search instead for 
Did you mean: 

Support 'Execute a SQL query' action through an on-premises data gateway

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 


The "Get rows" action allows users to pull records from a single table, but there is currently no way to pull records from multiple on-prem SQL tables. To avoid executing a complex query from Flow, some users have combined "Execute a stored procedure" to build a single table with "Get rows" to query it, but this workflow is also not supported with an on-premises data gateway.


Adding this functionality would create a great deal of opportunities for automation of testing and reporting on complex data structures.

Executing a Flow with this connector yields the following error:
  "message""Gateway ExecutePassThroughNativeQueryAsync\r\nclientRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7",


 Flow Error.PNG


Status: Completed
Super User

I will beg if I have to?

Not applicable

03/29 and still has this problem

Advocate I

Adding my voice to the mix, would make a project so much easier and save a bunch of time if this feature was available to on prem gateways.

The rest of the work I need to do is inside Flow so now I have to figure out a SECURE way of query my database and then sending that info to Flow to process the returned data.

Frequent Visitor

I echo that this would be a great addition.  I am also using the Stored Procedure to create a TempTable so I can then do GetRows.  Please add this functionality.


@Stephen- any thoughts on this? This seems like something that people would do relatively often...

Power Automate

Adding @SameerCh to advise if this is planned. Thank you for your patience.

Not applicable

Adding my interest

Not applicable

Adding my interest here too

Advocate II

Trying to find a work around but this would be huge.

Regular Visitor

Its also annoying that I cant execute simple MySQL statements with an on-prem data gateway.