Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
Ask a Question

Can Power Automate Connect to On-Premises SQL Server Without Using a Gateway?

0 like 0 dislike
3.3k views
in Power Automate by ●39 ●44 ●51
I want to create a Power Automate flow that interacts with an on-premises SQL Server. Is it possible to achieve this without setting up a Data Gateway?

1 Answer

0 like 0 dislike
by ●164 ●208 ●429

As a short answer: No,

To connect Power Automate with an on-premises SQL Server, a Data Gateway is required. The gateway acts as a bridge, ensuring secure data transfer between on-premises environments and the cloud.

See also On-premises data gateway Configuration

deBUG Community deBUG.to
If you don’t ask, the answer is always NO!
...