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: Completed
Comments
DavesTechTips
Super User

I will beg if I have to?

Anonymous
Not applicable

03/29 and still has this problem

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

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

ChrisKoenig
Microsoft

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

Audrie-MSFT
Power Automate

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

Anonymous
Not applicable

Adding my interest

Anonymous
Not applicable

Adding my interest here too

BARD
Advocate II

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

cdolan
Regular Visitor

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