Getting data from a function in an on-prem SQL server via Gateway in Power Automate

Dataflow magic in Power Automate. SQL with Power Query in Power Automate. Did you know you can do this?

CloudMinded Blog

“We are screwed!”

me at the moment of technology induced panic

That was the feeling when I saw the below error messages.

The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow…

Continue Reading Olena Grischenko’s Article on their blog

Getting data from a function in an on-prem SQL server via Gateway in Power Automate

CloudMinded Blog “We are screwed!” me at the moment of technology induced panic That was the feeling when I saw the below error messages. The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow integration, but this time we needed data from a function in Power Automate.

Blog Syndicated with Olena Grischenko’s Permission

Author: Olena Grischenko

Share This Post On