Dataflow Connect to AWS Postgresql

Hi yanain9 
Thanks for reaching out to the Microsoft Fabric Community Forum.

Currently, Power BI does not support direct manual certificate installation on the Power BI Service where Dataflow runs. Unlike the desktop version where it is possible to manually import certificates, the Power BI Service is a cloud-based service and cannot handle custom certificates directly.

1.Verify AWS PostgreSQL SSL Configuration
On the AWS side, ensure that the PostgreSQL instance is using a valid SSL certificate signed by a well-known Certificate Authority (CA). This step is important because the SSL certificate validation error often occurs if the PostgreSQL server isn’t correctly configured to handle secure connections.
AWS provides SSL certificates for RDS instances.
2. Download the RDS SSL certificate:

• Go to the AWS documentation on RDS SSL Certificates.
• Download the RDS root certificate (e.g., rds-combined-ca-bundle.pem) which is signed by Amazon and trusted by most systems.

3.Configure PostgreSQL Instance to Require SSL:

• In the RDS console, ensure that the parameter rds.force_ssl is set to 1 (enabled) so that only SSL connections are accepted.
• Restart the instance after applying this setting to ensure it takes effect.
  
  

4. After making these changes, test the connection from Power BI to ensure it connects successfully without SSL errors.

If you have any further questions or need additional help with this, feel free to reach out     to us for further assistance!

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.