powerbi postgres connector - remote certificate is invalid

Hello,

I keep getting errors trying to connect to a postgres SQL rds.amazonaws.com.
I have looked all around the places and tested but none seem to work. The only way i can get it working is by edit permission - untick encrypt connection and reconnect it again. The only issue with this is that not all the data/tables are shown. I been spending the last week trying to connect, restart PC , and installed drivers but nothing work. 

I can connect this on tableau postgres connector without any issues in less than 10 seconds - I just don't understand why it's so difficult with powerbi postgres connector. The only thing i noticed is that powerbi postgres connector doesn't require a port number so this might be the problem it causing? But i have no idea how to insert a port number if there is no box for this within powerbi progres connector.

Now through odbc driver.