I am able to connect to my SQL Server using On Premise gateway connector in Power Automate(MS Flow).#sqlserver #MSFlow
But when I try to execute action "Execute SQL Query (V2)" from SQL server connector to run simple query "EXEC * from TableName" shows error "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Get Native Sql Metadata) is currently not supported using an on-prem gateway connection".
Please see the below screenshot:
Yes that's correct. Unfortunately Execute a SQL query not supported an on-prem gateway connection.
You can post this as an idea for future release.
I just started using Flow and ran into this issue. Is there a work around?
Flow lets me click ellipse and add data gateway and error goes away...but then I get error when I run it.
If somebody is looking for this , I resolved with the "transform data query editor" action . In my case I needed a parameter , if you need create any and get from the previous action .