cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
americanmussel
Advocate I
Advocate I

SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

Hello!

I'm having trouble running a SQL Server query through my on-premises data gateway.

 

I can use the built-in "Get Rows" function to successfully return a set of rows, but I need to run a complex query that joins across several tables. When I try "Execute a SQL Query", it falls over with the following error:

 

{
  "status"400,
  "message""Gateway ExecutePassThroughNativeQueryAsync\r\nclientRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7",
  "source""sqlconnectionprovider-westus.tip0-westus.p.azurewebsites.net"
}

 

Has anybody seen this before? Any recommendations on how to solve this?

5 REPLIES 5
v-xida-msft
Community Support
Community Support

Hi @americanmussel,

 

Could you please share a screenshot of your flow’s configuration?

The “Execute a SQL query” action is not supported in Microsoft Flow using an on-premises gateway connection currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey v-xida-msft!

Thanks for the quick reply.

I've attached a screenshot to my Ideas post here:
https://powerusers.microsoft.com/t5/Flow-Ideas/Support-quot-Execute-a-SQL-query-quot-action-through-...

 

Let me know what other details I should provide! Hope we can get the support 🙂

Thanks,
americanmussel

yhlow72
Frequent Visitor

still no update up to now?
DSantos
Frequent Visitor

Tried querying a table from a database on my local machine using PA and got the following notification message:

 

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

 

Hence, querying a table that relies on on-prem gateway doesn't seem to be a priority item.

WPD_Rusty
Regular Visitor

Still nothing eh?

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.

Users online (1,436)