Postgres conection

The error usually happens because:

IP not allowed → Add your public IP in the Azure Postgres Firewall settings.

Port → Use 5432.

Username → In Azure it must be user@server.

SSL → In Power BI check Require SSL (Azure requires it).

👉 Most common causes: SSL not enabled or IP not added correctly.

Hi dzerain 

Could you please try these steps:

1. Go to settings->Networking->

Allow All IP -> Add 0.0.0.0 - 255.255.255.255

2. Test your connections, it should work fine.

When the above works.

i)Go to overview tab-> take postgresql endpoint

ii)Go to command prompt, do nslookup <endpointurl>

iii)Take the ipaddress and whitelist this particular ip in your organizations firewall

iv)Then check your ip and add this in the setting->networking->firewall rule

iv)you can remove allow all ip 0000-255.255.255.255 from the firewall rules

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi