How can I connect to SQL link Server for Power automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I am trying to connect SQL link server to Power automate, but I do not know how to start. Can anyone help?

Many Thanks

Emorn

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you confirm that you are trying to connect to your SQL server which is then linked to another SQL server and that your end goal is to execute a query on the linked server?

Are the SQL servers on premise / in a private network or publicly available in Azure?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Eric,

Yes that is right below is my SQL map

I would like to be able to pull out any of the tables below. Can you help?

Many Thanks
EMorn

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Is your SQL on prem or in Azure? Looking at the screenshot, it looks to be on premise which means you won't be able to use SQL query via the data gateway.

You can look into calling a stored proc that is on the server you have created the connection for and see if you can query your linked server that way? I know the stored proc executed via SSMS will execute the query successfully against the linked server.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No