cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mthaker
Helper I
Helper I

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

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 :

mthaker_2-1631110037118.png

 

Can anyone help on this ?

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
PrasadAthalye
Super User
Super User

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

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

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.

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

3 REPLIES 3
PrasadAthalye
Super User
Super User

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

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

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.

 

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.

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,674)