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\ncli entRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7 " , "source" : "sqlconnectionprovider-westus.tip0-westus.p.azurew ebsites.net" }
... View more