- Newest
- Most votes
- Most comments
Hi,
I understand you want to connect Microsoft Power BI directly to data sources in AWS VPC. According to the documentation you've mentioned [1], this is possible and it requires following components and configurations:
- An Amazon EC2 instance which has Microsoft on-premises data gateway in the same private VPC with your RDS and PostgreSQL server
- The private VPC subnet must have a route to a NAT gateway [2][3]
- The security group associated with your RDS and PostgreSQL server must allow the traffic from the EC2 instance that launched in step#1
Amazon Athena is another supported data source by the Microsoft Power BI gateway, and it is not required for such an use case.
I'd suggest you to kindly double check the VPC network and security groups configuration according to the above-mentioned steps. If the issue still persists, please don't hesitate to cut a technical support ticket from your AWS account with network or RDS topic, our support team will be happy to help you further troubleshoot and resolve the issue!
[1] https://docs.aws.amazon.com/whitepapers/latest/using-power-bi-with-aws-cloud/connecting-the-microsoft-power-bi-service-to-aws-data-sources.html [2] https://docs.aws.amazon.com/vpc/latest/userguide/nat-gateway-scenarios.html#public-nat-internet-access [3] https://aws.amazon.com/premiumsupport/knowledge-center/nat-gateway-vpc-private-subne
Relevant content
- asked 10 months ago
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago
Thanks Ethan_H, as you said I tried again the installation of the gateway and the EC2 instance and I noticed that there was some problems in the configuration of the ODBC. The EC2 had all the required settings such as same VPC, NAT routes, DB access, ODBC configs. But the issue was that the name of the ODBC driver was different from the one that I use in my computer. I did what they say in this reference 1 to match the driver name, I checked that the version and the type were the same and after that I corrected the name. After that I restarted the gateway on the EC2 then suddenly it worked. Now I can succesfully refresh the data on the PowerBi Service using the AWS gateway.