Power BI Integration with AWS RDS

Hi moe_elbohsaly ,

To switch your on-premise connection to Amazon RDS and configure it on app.powerbi.com, follow these steps:

1.Install Npgsql, which allows .NET access to PostgreSQL. Follow the instructions in these links:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

2.Connect to AWS over SSL
3.Download the AWS public key
4.Convert the key using SSL Converter (Current Certificate Type: Standard PEM, Convert to: P7B/PKCS#7)
5.Apply the certificate by importing it into the Trusted Root Certification Authorities on your local computer.
6.Test access from Power BI Desktop using the PostgreSQL connector.
7.To use it in Power BI Service, create a new data source in the Manage Gateways screen.

Please refer to the following documents for more information.

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

Connecting PowerBI to RDS PostgresQL on AWS | by Pallav Mathur | Medium

Best Regards,

Neeko Tang

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

Do you wish to connect remotely and figure things out? I follow the GMT+2 timezone