You’re offline. This is a read only version of the page.
50
I am trying to connect to execute SQL (custom query), through FLOW. But after providing of 'Server' and 'Database' name it's throwing following error.
The dynamic operation request to API 'sql' operation 'GetPassThroughNativeQueryMetadata_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native Sql) is currently not supported using an on-prem gateway connection.
Screenshot :
Can anyone help on this ?
Please refer following link. Under Known Limitations, Point 9 says that Execute SQL Query V2 is not supported for On Premise.
https://docs.microsoft.com/en-us/connectors/sql/
You can always connect to Azure SQL to query data.
Thanks Prasad!
I could able to execute StoredProc through 'Execute Stored Procedure (V2)'. I can query single table through 'Get row (V2)' and do various 'server actions' provided under 'SQL server' connection.
My query (now) is,
What is the purpose of providing an option 'Execute a SQL Query (V2)' in the cloud when it's not working ?
And if it's working then wanted to know that alternative, to get data with it.
Execute Native SQL using On Premise Gateway is not supported at the moment..
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
