Can't connect to postgresql database (Linux server on the cloud)

bdaoudi , PostgreSQL should be SSL enabled.

You need to download the certificate and import it into windows.

You also need the latest driver: https://www.nuget.org/packages/Npgsql/6.0.0-preview3

Also, make sure you have access to database on the machine using pgadmin

refer for detailed steps

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

HI bdaoudi,

Have you added the SSL certificate to the device installed the power bi gateway client for your data connection?

In addition, please check the configuration folder of the PostgreSQL server to confirm SSL settings are correctly configured.

BTW, you can also take a look at the following link about power bi service white lists if they blocked by device policy/configurations.

Add Power BI URLs to allow list - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng