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 🙂
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!