Powerbi Service to Amazon Redshift Private cluster

[vikkidurai91]

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

[ktaws]

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.

[Icey]

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

[Icey · Accepted solution]

Hi @vikkidurai91 ,

One on-premise data gateway is needed.

And here is a detailed post, it may help you: Integrate Power BI with Amazon Redshift for insights and analytics.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

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.