Forum Discussion

vikkidurai91's avatar
vikkidurai91
Helper I
6 years ago
Solved

Powerbi Service to Amazon Redshift Private cluster

Hello

 

We want to connect to Amazon Redshift cluster, which is in private subnet from PowerBI service, but we are not able to connect. We like to have a Direct Query instead of import option and a refresh for 15 mins. instead of 30mins..

 

I see a post of 2018, saying that we need to use Gateway in EC2 machine, but this will not give us an option to use Direct Query feature.

 

Could someone please help if it's possible to connect to private Amazon Redshift cluster from PowerBI service, without GATEWAY

 

 

Thanks

Vignesh

 

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Wait, why won't using a Gateway work with Direct Query to Amazon Redshift? People use a Gateway with Direct Query all the time. You just have to make sure that you are using the Enterprise gateway, not the Personal gateway.

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi vikkidurai91 ,

     

    Is this problem solved?

     

    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.

     


    Best Regards
    Icey

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Data Gateway is it must even with latest version?

    I am able to connect directly from Power BI Desktop to Redshift cluster that is in VPC. I am in the initial stages of integration. Haven't published a report to validate if the connection is flawless.