cancel
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:
{
  "status"400,
  "message""Gateway ExecutePassThroughNativeQueryAsync\r\nclientRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7",
  "source""sqlconnectionprovider-westus.tip0-westus.p.azurewebsites.net"
}

 

 Flow Error.PNG

 

Status: New
Comments
Super User II

I will beg if I have to?

Regular Visitor

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.

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

Microsoft

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

Regular Visitor

Adding my interest

Anonymous
Not applicable

Adding my interest here too

Advocate I

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.