Unanswered

SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

(5) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (0)

v-xida-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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-an-on/idi-p/69514#M4819

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

Thanks,
americanmussel

Was this reply helpful? Yes No
yhlow72 20 on at

Like (2)

Report

still no update up to now?

Was this reply helpful? Yes No
DSantos 7 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
WPD_Rusty 3 on at

Like (0)

Report

Still nothing eh?

Was this reply helpful? Yes No
JLo 30 on at

Like (0)

Report

I have the same issue. The workaround I use is too create a view on the database. You can use the Get rows pointing to the view.
The only problem (for me) is that every time I need a new view or update one, I need to involve IT as I cannot do it myself.

Was this reply helpful? Yes No