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
Community Champion
Community Champion

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

4 REPLIES 4
PrasadAthalye
Community Champion
Community Champion

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

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
nals
Microsoft
Microsoft

Its a azure SQL and im still facing tihs issue

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,692)