Unable to pull data from Postgres Database

[Cesylyaa]

Hello,

I am trying to connect to a Postgres Database.
I keep getting this error: 

Please help.

[Anonymous]

Hi @Cesylyaa 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @Cesylyaa - it looks like the error message you're encountering suggests that Power BI is unable to connect to your PostgreSQL database due to a network-related issue. 

Ensure that PostgreSQL is configured to accept remote connections. You can check the postgresql.conf file for the listen_addresses setting (it should include the IP address of the server) and the pg_hba.conf file to ensure the correct client IP range is allowed.

Verify that you are using the correct ODBC driver version that matches your PostgreSQL server version. If not, try updating or reinstalling the driver.

Cross verify the username, passwrd database connections entered are correct 

ref: 

Ways to Fix Problems Connecting to the PostgreSQL Server - Sling Academy

PostgreSQL “Could not connect to server” Error: How to troubleshoot - IONOS

NpgSqlException "connected host failed to respond" · Issue #1548 · npgsql/npgsql · GitHub

How To Configure PostgreSQL to Allow Remote Connections – TecAdmin