Forum Discussion
Power BI DataGateway for AWS Redshift
Hi,
I was configuring a Power BI Data Gateway to AWS Redshift using these solutions: https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/ and https://d1.awsstatic.com/whitepapers/using-microsoft-power-bi-with-aws.pdf?did=wp_card&trk=wp_card. In short, I need to
- Launch an EC2 Windows instance in the same private subnet of the Redshift cluster.
- Download and install Microsoft On-premises Data Gateway in the EC2 instance.
- Configure the network including NAT gateway and Internet gateway for the VPC.
- Configure the data gateway in Power BI Service using the organizational account.
However, I only completed step 1, 2 and 4, then the Power BI Service was able to reach the On-prem Data Gateway and get the latest data from Redshift and refresh the dashboard. This raised some security concerns: the Windows EC2 instance is under a private subnet in a VPC which only allows outbound traffic and doesn't allow inbound traffic, then how does the Data Gateway get request and retrieve and send the data to Power BI Service?
I need to understand how the Data Gateway works and how the networking flows in this scenario then I am more comfortable with this solution.
Hey Anonymous ,
that's because the gateway uses only outbound connections to Azure Service Bus. There are not inbound connections:
On-premises data gateway FAQ | Microsoft Docs
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
1 Reply
- selimovdMost Valuable Professional
Hey Anonymous ,
that's because the gateway uses only outbound connections to Azure Service Bus. There are not inbound connections:
On-premises data gateway FAQ | Microsoft Docs
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic