Failed to update data source credentials: The PostgreSQL source doesn't support encrypted connection

[YZhou]

When I update the data source credentials in PBI service, it has an error: Failed to update data source credentials: The PostgreSQL source doesn't support encrypted connections. Any ideas to resolve it?

Thanks. 

[Anonymous]

Hi @YZhou  

SSL/TLS connectivity relies on certificates for encryption. For Impala and other ADO.NET-based connectors, the system trusted store is used to validate server certificates. Use the following SSL guide to diagnose and mitigate these issues: SSL Troubleshooting Steps

For SQL, PostGreSQL, and other ODBC sources that allow cloud refresh, only certificates signed by a trusted certificate authority already present in the PowerBI Service trusted certificate store will be able to successfully establish SSL connections. If the certificate authority used for the customer's server is not one of these certificates, we recommend using a gateway. The gateway trusted certificate store can be configured in the directions Here

Simba ODBC drivers including Redshift, Databricks and Snowflake (online services) include a .pem file containing the correct certificate to be used for the service. The driver will use this certificate instead of consulting the system trusted certificate store. These .pem files will already be present in PowerBI Service with the drivers, so cloud refreshes will be able to establish SSL connections.

Best Regards,
Community Support Team _ Ailsa Tao

[julienkeruzec]

I have the same issue,

With PowerBI Desktop, I can set my PostgreSQL certificate inside Windows certificate store but as I switch for PowerBI App online.

I can see my connection source, I can set the encrypted option but no option to input the certificate to be valided and so I have this error.

Uncrypted source is well working though but not secured ... 😕

Thanks for your help,