Forum Discussion
PostgreSQL ODBC auth failed
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 :
- Tried to update Power BI to newest version
- Removed %25 from password
- Tested connection via ODBC client which is OK
- Deleted Credentials from Power BI
- 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...
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://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.
4 Replies
Anonymous , Please Open File -> About and please let us know the version of Power BI?
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://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.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.
