cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
americanmussel
Level: Powered On

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?

3 REPLIES 3
Community Support Team
Community Support Team

Re: SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

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.
americanmussel
Level: Powered On

Re: SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

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
Level: Powered On

Re: SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

still no update up to now?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 342 members 6,641 guests
Please welcome our newest community members: