DataSource.Error: ODBC: ERROR [08001]

[Alex_Ooi]

Hi all, I am connecting to my PostgreSQL dB using ODBC for Power BI. When I tested my connection in ODBC, it worked fine. When I tested the connection again in my IDE, it worked fine.

When I am trying to establish connection to Power BI, it returns this error message:

DataSource.Error: ODBC: ERROR [08001] could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5431?
FATAL: password authentication failed for user "readonly"

I don't know what's wrong because I am very sure the password is exactly what is given to me by my IT admin guy. Please help.

[CFTeam]

having the same error here, in windows too, could you manage to solve it @Alex_Ooi ?

[Anonymous]

@Alex_Ooi 

Try the troubleshooting solution here: https://www.ionos.com/community/hosting/postgresql/troubleshoot-a-postgresql-could-not-connect-to-se...

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

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alex_Ooi]

@Anonymous I don't think this is applicable to me as I am using Windows OS. Apologies for not mentioning this earlier.

[amitchandak]

@Alex_Ooi , are you giving correct url, it looking for localhost?

[Alex_Ooi]

@amitchandak hi, thanks for your reply. Yes, I am giving the correct url. Like I said, there is no problem with the connection when I established it in ODBC and my IDE.