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:
"message": "Gateway ExecutePassThroughNativeQueryAsync\r\nclientRequestId: 0a3e8a93-45a6-4f29-ad28-d4375b6963a7",
Has anybody seen this before? Any recommendations on how to solve this?
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:
Thanks for the quick reply.
I've attached a screenshot to my Ideas post here:
Let me know what other details I should provide! Hope we can get the support 🙂
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.