Forum Discussion
Connectivity issue with PostgresSQL Database connector in latest version of Power BI Desktop
Our datamart is running on a Azure Database for PostgreSQL - Flexible Server, and we have been using the PostgreSQL Database connector to access the database.
The database is setup with SSL ON and "require_secure_transport" ON (Whether client connections to the server are required to use some form of secure transport.).
We haven't had any issues with this previously, but with the latest release of Power BI Desktop (2.137.751.0 64-bit - October 2024) we aren't able to connect any more with the following error:
However, if I turn "require_secure_transport" off, the connection works fine (if I choose to access the data source with unencrypted connection), but this is not an option for us.
I am still able to connect to the databse using Azure Data studio, and the Power BI gateway used by the Power BI Service does not have any issues connecting, so the problem persists only in the October release of Power BI Desktop.
I tested the september release of Power BI, and that works without any issue.
Hi all,
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,
Gao
Community Support Team
11 Replies
Hi all,
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,
Gao
Community Support TeamThanks for the feedback Gao, I have tested the new verison and it works fine
Same problem here. Power BI October 2024 can't connect to Azure Postgres Flexible Server. Revert to September resolves it. Thanks for the post, was driving me mad.
Hi OAasPro - Since you've mentioned that the September version works fine, you could temporarily revert to that version until Microsoft resolves the issue with Power BI's October release.
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
from your end cross check that the SSL certificate required for connecting securely is correctly installed on the machine running Power BI Desktop.Sometimes, Power BI Desktop requires you to manually install the SSL certificate used by the PostgreSQL server.
For a quick solution, rolling back to the September version or adjusting your SSL setup in Power BI Desktop is likely the best way forward.
We experienced the same problem; installing the database's certificates onto the dev machine that is running PowerBI Desktop had no effect on connectivity.
We did notice that of the 3 files provided there, the DigiCert Global Root G2 was a .crt.pem file instead of a .crt file, so we did not install that one.
I also tried adding the three certificates to Trusted Root Certification Authorities in Windows (mmc) with no effect
We are experiencing the exact same issue when connecting to Azure PostgreSQL Flexible Servers and also had to revert to the September release. So this seems to a Power BI issue and not a certificate or server issue.
Hello,
We are having the same problem.
Best regards,
I have tried to report this as a bug, but I don't have access to create a support request since this has to be done by our microsoft partner.
Is there any other channel that could be used to file a bug report?
Microsoft has reported a known bug with postgresql connector as resolved on October 9th:
https://learn.microsoft.com/nb-no/fabric/get-started/known-issues/known-issue-850-postgresql-connections-additions-updates-fail?wt.mc_id=fabric_inproduct_knownissues
But I am not sure if this is the source of the new bug, or if it might fix this issue
