Encrypted Support Message

[rob_9]

Hi, I'm getting the following error message when connecting to a postgres data source. Our reports are enabled using cloud connection. So, a solution without enabling a gateway is prefferable as that's the reason for selecting this data source. 

EDIT: After speaking with support, I rolled back to the July version before updates to connectors and it's working in the interim (not a perfect solution I know). But it's allowing me to update and publish changes as expected.

[Anonymous · Accepted solution]

Hi all,

Thank you all for your patience.

New version with fix has been published to download center Download Microsoft Power BI Desktop from Official Microsoft Download Center (version 2.137.1102.0). It will be updated/available in Microsoft Store in few hours.

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.

[Anonymous]

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.

[gjlooms]

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.

[rob_9]

Spoke with support, I rolled back to the July version before updates to connectors and it's working in the interim (not a perfect solution I know). But it's allowing me to update and publish changes as expected.

[rob_9]

I also had the same issue last month as you mentioned. I suspected it was related to the previous ongoing issue. Incredibly annoying regarding the lack of transparency around causes/solutions from MSFT. 

[rajendraongole1]

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