cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EmornKui76
Frequent Visitor

How can I connect to SQL link Server for Power automate

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

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

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.  

 

ericcheng_0-1628846827831.png

--------------------------------------------------------------------------
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

View solution in original post

3 REPLIES 3
eric-cheng
Solution Sage
Solution Sage

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

Hi Eric,

 

Yes that is right  below is my SQL map 

 

EmornKui76_0-1628843716174.png

 

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

 

Many Thanks 

EMorn 

 

eric-cheng
Solution Sage
Solution Sage

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.  

 

ericcheng_0-1628846827831.png

--------------------------------------------------------------------------
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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Top Solution Authors
Top Kudoed Authors
Users online (3,216)