Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Using Connectors / Powerautomate On Premi...
Using Connectors
Unanswered

Powerautomate On Premise Gateway and Amazon Redshift

(0) ShareShare
ReportReport
Posted on 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,495 on at
    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 14 on at
    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 
     
     
     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,745

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans