I just wanted to share the observation that the error message Power Query pushes out, when a connection attempt to a PostgreSQL database fails, is not really helpful.
Even if you type in a non existent IP address or non existent database, there seems to be just one error message that is presented to the user: Connection not successful, try to change the encryption settings.
It would be tremendously helpful to have the possibility to view
a) proper error messages
b) a log file that shows the actual connection issue for debugging.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.