Unanswered

Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native Sql) is currently not supported using an on-prem gateway connection

(0) Share

Report

Posted on by mthaker

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 ?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

PrasadAthalye on at

Like (1)

Report

Execute Native SQL using On Premise Gateway is not supported at the moment..

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-action-through-an-on/idi-p/69514

Was this reply helpful? Yes No
mthaker 50 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

PrasadAthalye on at

Like (1)

Report

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.

Was this reply helpful? Yes No
nals Microsoft Employee on at

Like (0)

Report

Its a azure SQL and im still facing tihs issue

Was this reply helpful? Yes No