Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.