Unable to Run SQL Query on On-Prem Database via Power Automate - Any Alternatives?

(0) Share

Report

Posted on by razec18

123

Hi everyone,

I’m trying to run a simple SQL query on my on-premises SQL database using Power Automate, but I’m unable to get it to work.

Is there any alternative solution that you could recommend to query the on-prem database via Power Automate or perhaps another method that might be more suitable?

Any suggestions would be appreciated. Thanks in advance for your help!

Categories:

Building flows

Screenshot_187.png

I have the same question (0)

All responses (5)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

What setup did you use in the connection? Can you share a bit more details about that configuration (which authentication for example?)

Alternatively, have you tried desktop flows (Power Automate Desktop) instead of cloud flows?

Desktop flows also have Database type of actions:

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/database

Was this reply helpful? Yes No
razec18 123 on at

Like (0)

Report

Hi, I used exactly SQL Server Authentication.

The point to use Cloud Flows it's because of cost reduction.

To use a Desktop Flow, I would need a VM to do it.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Can you share the code view of your action? What query were you trying to use? Just trying to figure out why your current setup is not working. SQL authentication should work if you got a working on-prem gateway setup.

Regarding desktop flows. You don't necessarily need to run it on a VM btw, you have different setup options for Power Automate Desktop.

https://learn.microsoft.com/en-us/power-automate/guidance/planning/attended-unattended

You can even run it attended on your own machine (which is probably not the preferred way, but it is possible). It depends a bit on your requirements.

Was this reply helpful? Yes No
razec18 123 on at

Like (0)

Report

Im just trying to select some items from a table. And it seems that the issue only happens when I use Execute SQL Query V2

With other connectors of SQL, I can use it properly, and it works with my on premises data gateway.

Was this reply helpful? Yes No
Verified answer

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

That's a well known artificial limitation. One workaround is to create a Stored Procedure for each of your queries.

Was this reply helpful? Yes No