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

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Kudoed Authors
Users online (3,224)