Forum Discussion

rob_9's avatar
rob_9
Advocate I
1 year ago
Solved

Encrypted Support Message

  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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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