Skip to main content

Notifications

Community site session details

Community site session details

Session Id : h16U+2ZmYwxp12dBHtx80V
Power Automate - Using Connectors
Unanswered

Unable to connect To AWS Redshift with Power Automate

Like (4) ShareShare
ReportReport
Posted on 7 Apr 2022 08:52:03 by

Using Power Automate I want to connect with Amazon Redshift but can't establish connection.

I am getting below error.

 

ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? inner exception: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? clientRequestId: 55e3d9ca-1fc0-45f4-8106-971ed19cd682

 
Could you please help me to resolve this.
  • franciscooa Profile Picture
    78 on 13 Apr 2023 at 09:30:53
    Re: Unable to connect To AWS Redshift with Power Automate

    Hello!

    I have the same issue as you mentioned @Anonymous. Any update?

     

    Regards

  • Hairy_Drumroll Profile Picture
    246 on 09 Feb 2023 at 03:37:25
    Re: Unable to connect To AWS Redshift with Power Automate

    With the ip address being a 10.* address, it looks like you need to make sure you're using an On-Premises Gateway. My problem is that the screen to add the connection doesn't allow me to select a gateway!

     

    Edit: If I create a new Dataflow, I can select Redshift as the data source, then in the next config screen I can select a gateway. I don't need to save the dataflow, the connection is created regardless.

  • rajwm Profile Picture
    6 on 15 Nov 2022 at 20:18:53
    Re: Unable to connect To AWS Redshift with Power Automate

    Hi, I'm getting the same error. Trying to connect to redshift serverless. Did you find a way past this? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Connectors

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 6 Super User 2025 Season 1

#2
KT-07051015-0 Profile Picture

KT-07051015-0 4

#3
GI-06050833-0 Profile Picture

GI-06050833-0 2

Overall leaderboard

Featured topics

Loading started