SQL Server On-Prem Gateway Error: GetPassThroughNativeQueryMetadataAsync

[americanmussel]

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?

[v-xida-msft]

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

[americanmussel]

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]

still no update up to now?

[DSantos]

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]

Still nothing eh?