Encrypted Support Message

Same issue here. Seem to be the same in this topic: Connection issue: We couldn't authenticate with th... - Microsoft Fabric Community

This was also happening in the faulty PowerBI Desktop release of last month that was rolled back.

Hi rob_9 ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.

The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

In the meantime, it is recommended that you temporarily roll back to a previous version to resolve this issue.

Best Regards,

Clara Gong

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

Hi rob_9  - Allow Unencrypted Connections: The error message provides the option to use an unencrypted connection. If security policies allow, you can click "OK" to connect using an unencrypted connection. This will allow Power BI to connect to the database, but without encryption.

Enable SSL on PostgreSQL: To use an encrypted connection, you could configure PostgreSQL to support SSL by following these steps:

Ensure that PostgreSQL is compiled with SSL support.
Update PostgreSQL's postgresql.conf file to set ssl = on.
Provide the necessary SSL certificates and restart the PostgreSQL service. This ensures that Power BI can connect using an encrypted connection.
PostgreSQL Configuration for Cloud Use: If your PostgreSQL instance is hosted on a cloud provider (e.g., AWS, Azure, etc.), check that SSL is enabled and properly configured in the cloud setup. Cloud-hosted databases often have default SSL configurations that require specific client-side configurations.

PostgreSQL: Documentation: 17: 18.9. Secure TCP/IP Connections with SSL