How can I connect to SQL link Server for Power automate

[EmornKui76]

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

[eric-cheng]

Hi @EmornKui76 ,

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

[EmornKui76]

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 

[eric-cheng · Accepted solution]

Hi @EmornKui76 ,

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