How connect to the AWS RDS database from app.powerbi.com?

[Anonymous]

Hi Power BI community, I am out of curious if it is possible to connect Power BI to our AWS RDS instance, located in a private subnet, directly using a private endpoint, etc? Is there a solution to this?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Microsoft Power BI service (SaaS) can be connected directly to internet-accessible data sources, or to private data sources in an Amazon VPC. Connection to private data sources requires an application component called Microsoft on-premises data gateway. The Microsoft on-premises data gateway is downloaded and installed on an Amazon EC2 instance in the VPC and configured with Microsoft Power BI credentials. The gateway establishes an outbound connection to the Microsoft Azure Service Bus over the internet, and is configured in Microsoft Power BI to connect to data sources that it can access. Larger deployments can use multiple on-premises data gateways to balance load or increase fault tolerance.

For more you may refer to Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AWS Cloud (amazon.com)

How To Connect Power BI to an AWS RDS SQL Server | by WCI Data Solutions | Medium

Best Regards,
Community Support Team _ Caitlyn

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