Major problem: Can't connect to PostgreSQL in new version

[andyclap]

We use a postgres database (Azure managed database).

Since the last desktop update - Version: 2.137.751.0 64-bit (October 2024)

We are getting an error on our postgres data sources:

"We couldn't authenticate with the credentials provided"

The credentials are correct, and work on previous versions of PBI desktop.

When clicking edit credentials we receive the error

"Encryption Support

We were unable to connect to the data source using an encrypted connection. To access this data source using an unencrypted connection, click OK"

Clicking OK removes the encrypted flag from the datasource and returns the "We couldn't authenticate with the credentials provided"

[rajendraongole1 · Accepted solution]

Please scroll down a little , you can see the below snapshot

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

Let me share it 64 bit

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

32bit:

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

[v-cgao-msft · Accepted solution]

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

[Katerina_SL]

Hello Everyone!

I encountered the same issue after installing the October version of Power BI. Reinstalling the September version resolved it for me.

Thank you!

[Sean_Page]

Same issue, spoke with support and downgraded with them on the call to show that it was in fact the update that broke it. Thanks for the suggestions!

[andyclap]

Just had a support call, and it seems this is likely to be a bug with the latest version. They are reporting it to the product team.

[MockIT2As]

Can Mock Assessment be pre-filed to gain access in all area's of Management.

[andyclap]

OK - thanks for the link (slightly confusing as the highlighted download section for each version linked to the latest version rather than the specific version - yes as you say the links are at the end of each section).

Reverting to the Sept version fixes this issue.

Version: 2.136.1478.0 64-bit (September 2024)

Looks like a bug introduced in the October version somehow - I've raised a support ticket around this.

[rajendraongole1]

Yes, it is an issue with october release, you can revert back the changes. 

Untill the issue fixes in latest release, you can use the september release. if this issue fixes, please accept it as solution.

Thank you.

[josed_bi]

Hi, is there a ticket or another post we can follow up to know when this gets resolved? I'm worried we can't use this connector with the latest versions. Thanks.

[v-cgao-msft]

Hi all,

The product team created this ICM internally and engineers are investigating this issue. If there is any news, I will synchronize it below.

Best Regards,
Gao
Community Support Team

[rajendraongole1]

Hi @andyclap - If Power BI is asking you to remove the encryption flag.If the PostgreSQL server does not support encrypted connections, ensure it's configured correctly for unencrypted connections (but note this may introduce security risks).

Since the problem appeared after the October 2024 update, you can temporarily roll back to a previous Power BI Desktop version that worked. Download earlier versions from the Microsoft Download Center or Power BI's official site.

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

crosscheck , your Azure PostgreSQL version is compatible with the latest Power BI Desktop updates. Some TLS-related changes or driver updates might cause compatibility issues.

[andyclap]

The database is an azure managed database.

The previous version of powerBI desktop was connecting OK, and no other app is having problems (PowerBI service is OK).

(Edit - found link to older version in provided link, trying older version now).

[rajendraongole1 · Accepted solution]

Please scroll down a little , you can see the below snapshot

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

Let me share it 64 bit

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

32bit:

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...