Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id : 2Z8aLnpPInwPhBnzITZzsc
Power Platform Community / Forums / Power Automate - Using Connectors / Powerautomate On Premi...
Power Automate - Using Connectors
Unanswered

Powerautomate On Premise Gateway and Amazon Redshift

Like (0) ShareShare
ReportReport
Posted on 4 Sep 2024 09:57:04 by CU04090950-0
Hi
 
We have been able to connect PowerBI to Amazon Redshift using a On Premise Data Gateway.   We are trying to do the same for Power Automate.  However when we install the Gateway for PowerAutomate it doesn't seem to have a connector for Amazon Redshift.   Is Amazon Redshift supported or is this only available at present on the PowerBI On Premise Data Gateway?
 
We have also tried connecting directly from cloud version of Power Automate to Amazon Redshift, but we believe we have firewall issues when trying to do this.
 
Cheers
 
John
Categories:
Licensing
  • lbendlin Profile Picture
    lbendlin 7,873 Super User 2025 Season 1 on 19 Sep 2024 at 23:26:21
    Powerautomate On Premise Gateway and Amazon Redshift
    You can technically use the same gateway for Power BI and Power Automate  but you made the right decision to keep them separate as the connection management is very different.  Power Automate connection creators must be listed as such on the gateway.
     
    As long as you have that role you should be able to create the Redshift/Athena connection in your flow.
  • jd38 Profile Picture
    jd38 20 on 18 Sep 2024 at 14:53:12
    Powerautomate On Premise Gateway and Amazon Redshift
    Hi, 
    I'm facing the same issue with AWS redshift connector. 
    You need a gateway to access to your DB. The problem is that the connector is in "Preview" and doesn't let you select a gateway. It's just a checkbox that say "use onPrem data gateway" but you can't select the gateway you want. 
     
    From our side, we decided to test to use PostgresSQL. 
     
    regards 
     
     
     

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

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
DBO_DV Profile Picture

DBO_DV 25 Super User 2025 Season 1

#2
CU09051456-0 Profile Picture

CU09051456-0 22

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 12 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans