Forum Discussion
ODBC Connection - "Password authentication failed" error
Hello all,
I am having trouble with using the ODBC connection in Power BI Desktop.
I have configured the dns data source in Windows settings and then used this data source in ODBC connection in my report to import tables from PostgreSQL database. Everything until now worked perfectly, including data refresh.
However, when this report is opened on other PC, the following error message will appear when trying to refresh data:
ODBC: ERROR [08001] FATAL: password authentication failed for user ...
The other PC has the data source configured exactly the same way, incl. the name of the data source (and connection test is succesful). Also, importing additional tables using the ODBC data source works fine, just the existing tables will not refresh.
Any ideas what may be causing the error?
Thanks in advance
1 Reply
Hi aab ,
Try the troubleshooting solution here: Troubleshoot a PostgreSQL "Could not connect to server" Error - IONOS
To correct this, edit your posgresql.conf file:
- Ubuntu 16.04: sudo nano /etc/postgresql/9.5/main/posgresql.conf
- CentOS 7: sudo nano /usr/pgsql-10/share/postgresql.conf
Hope this similar post helps you:
Solved: PostgreSQL ODBC auth failed - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
