Getting data from a function in an on-prem SQL server via Gateway in Power Automate
The article discusses the challenges faced when trying to retrieve data from a function in an on-prem SQL server via an on-prem Gateway in Power Automate. The author encountered two setbacks: the inability to use "Execute a SQL query (V2)" with an on-prem gateway connection and the inability to return a dataset from the function. However, the author found a solution using Power Query. By using "Transform data using Power Query," it is possible to return data from a function or stored procedure in an on-prem gateway. The author also mentions the additional capabilities of Power Query, such as adding calculated fields, joining datasets, and performing various transformations. The article concludes with a disclaimer that it is currently not possible to pass a value from the flow into the DB function.
Article 50m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time