Cannot connect to PostGreSQL database

[JadS]

Hello everyone,

I'm encountering an issue when trying to connect to a database from Power BI. Here are the details:

• I'm using Power BI to connect to a remote database.
• When I try to establish the connection, I get an error related to the SSL certificate: "The remote certificate is invalid according to the validation procedure."
• However, I can connect to the same database through DBeaver without any issues and can view and interact with the data.
• I've also performed a Test-Connection using PowerShell to check the network connectivity, and I can successfully ping the server without any problems.

PowerShell Test-Connection:

The network connectivity test shows that the machine can reach the server, so I believe the issue is specifically related to SSL certificate validation.

Steps I've taken so far:

• Verified the network connectivity—no issues there.
• I suspect the problem might be with the SSL certificate, but I'm not sure how to address this in Power BI. I'm not certain if the server is using a self-signed certificate or another untrusted source.

My Question:

Has anyone encountered this kind of SSL certificate issue with Power BI before? Is there a way to bypass SSL validation in Power BI (for testing purposes) or a method to import a non-recognized certificate? Any suggestions would be greatly appreciated!

Thanks in advance for your help!

[Anonymous]

Hi @JadS ,

Regarding the previous issue with Power BI Desktop connecting to PostgreSQL databases, an updated version containing a fix has been released.
Solution:
The fix has been released to the Download Center and you can download it at the following link:

Download Microsoft Power BI Desktop from Official Microsoft Download Center
In the meantime, this version will be updated and available on the Microsoft Store within a few hours.
We recommend that you download and install the latest version as soon as possible in order to resolve this issue. If you have any other questions, please feel free to contact us.

[Anonymous · Accepted solution]

Hi All,

Firstly  amitchandak thank you for your solution!

And @JadS ,

Hello, thank you for your feedback on the issue you are experiencing when connecting to PostgreSQL databases using Power BI Desktop.
Based on the information we have at this time, this issue primarily affects users using the October 2024 release of Power BI Desktop, specifically when connecting through the PostgreSQL native connector, and you may see an error message similar to the one you are currently experiencing.
The root cause of this issue is a change in version 4.0.16 of the npgsql driver, which is currently being worked on to fix. At this stage, you can refer to the following interim solutions to help you continue to use Power BI:
Interim solution:
Rollback to September 2024 version of Power BI Desktop: You can uninstall the current October version and temporarily use the September version of Power BI Desktop, which is not affected by this issue.
Manually install npgsql driver 4.0.10: If you prefer to continue using the October version of Power BI Desktop, you can replace the current version (4.0.16) by manually downloading and installing the npgsql version 4.0.10 driver. This action should avoid this encrypted connection issue.
Currently, the development team has prepared a new version with the fixes and is in the process of internal validation and testing. The new version is expected to be released by the end of October 25th. At that time, you will be able to completely resolve this issue by updating to the latest version of Power BI Desktop.
If you have any other questions or need further assistance, please feel free to contact me and thank you very much for your understanding and support! 

[amitchandak]

@JadS , If you are using an RDS, then try this setting

RDS Parameter group, Change the value of rds.force_ssl from 1 to 0

Also, you need make sure all these in case of Postgresql server

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/