ODBC Connection - "Password authentication failed" error

[aab]

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

[v-stephen-msft]

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.