Cannot connect to PostGreSQL database

Hi All,

Firstly  amitchandak thank you for your solution!

And Anonymous ,

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!