PostgreSQL ODBC auth failed

[Anonymous]

Hi there, Previosly I had issue accessing PostgreSQL ODBC database which was resolved by adding %25 in my password as it is explained here - https://community.powerbi.com/t5/Desktop/PostgreSQL-ODBC-to-PowerBI-Password/td-p/874856

I do not know when did it happen but couple days ago I stumbled upon that I'm having same issue, I've done couple things to solve it which was not successfull, I'm gonna list them below :

1. Tried to update Power BI to newest version
2. Removed %25 from password
3. Tested connection via ODBC client which is OK
4. Deleted Credentials from Power BI
5. Tested another Postgresql odbc database connection, which was successfull.

Any ideas how to solve it or what can be reason?

Error I'm getting : ODBC: ERROR [08001] FATAL: password authentication failed for user...

[meganwei]

This is failed due to an incorrect password in two places, powerbi and odbc.

Solution:

1. go to odbc and chagne password for the data source 

2. go to powerbi app -->file-->options and settings -->data source settings -->select the data source--> edit permission --> click edit button --> edit passwrod. 

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to my research, messages like this indicate that you contacted the server, and it is willing to talk to you, but not until you pass the authorization method specified in the pg_hba.conf file. Check the password you are providing, or check your Kerberos or ident software if the complaint mentions one of those authentication types.

Hope these help.

https://medium.com/@uchehenryigbokwe/how-to-bypass-password-authentication-for-windows-users-in-postgresql-969b9ab97406

https://stackoverflow.com/questions/7695962/postgresql-password-authentication-failed-for-user-postgres

https://stackoverflow.com/questions/55038942/fatal-password-authentication-failed-for-user-postgres-postgresql-11-with-pg/55039419

https://knowledgebase.progress.com/articles/Article/7879

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Please  Open File -> About and please let us know the version of Power BI?