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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!