Im trying to execute a stored procedure using powerapps, the source of the app is an on premesis server. I saw in the past that it was not possible to run an on-prem stored proc via Flow. Is this possible now? If not, has anyone heard of a time as to when this may be available?
Solved! Go to Solution.
Dear Flow Team,
Any news on executing stored procedure with On-Premises Gateway server ?
I see from the previous posts plans were made to make this feature available by now. No pressure 🙂 just checking if there is an ETA for that ?
Like many others that are viewing this thread, I registered to post just so I could say that I too am waiting for a solution to Execute a Stored Procedure by way of the On-Premise Gateway server. Can anyone provide an updated ETA or a possible workaround? I wanted to create a simple PowerAPP that would connected to my on-premise SQL server and run a simple stored procedure. However, I've only been able to create a PowerAPP that will browse my db tables (and their rows).... Cool, but not exactly useful. Any information on executing a stored procedure would be appreciated. Thanks for reading.
Hi all, a quick update. We have released the ability to run stored procedures via on-premises gateway servers.
Please note that this feature is in Preview.
Anyone have any updates on the status of this ?
Was original due out in 2016.
If its in Preview mode how do we access the on premise preview version ?
Getting - "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Get Native Sql Metadata) is currently not supported using an on-prem gateway connection clientRequestid: F8CBC37B-2699-4873-8909-8869C84F7A4A.
Any luck with this?
I am getting the same when trying to create a flow to execute a SQL query, but it doesn`t seem to like the onprem gateway.
Flow now does support Stored Procedure calls over On-Premises Data Gateways. Here are the steps to enable it:
Hope it helps.