Unable to disable Encrypt connections

Thanks for the reply from amitchandak , please allow me to provide another insight: 
Hi  milletf1 ,

You can check the solutions for the same error message below and try connecting to AWS via SSL by setting the relevant information: 

Solved: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Fabric Community

Alternatively, you can try using ODBC to connect to PostgreSQL.

Solved: How to fix Invalid Certificate on postgresql serve... - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community

database - Power Bi PostgreSQL data import error - The remote certificate is invalid according to the validation procedure.'" - Stack Overflow

postgresql - AWS RDS Postgres Connection issue to Microsoft Power BI: "The Remote certificate is invalid..." - Stack Overflow

windows - An error happened while reading data from the provider. The remote certificate is invalid according to the validation procedure - Stack Overflow

Best Regards,

Liu Yang

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