Forum Discussion
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
Hi dzerain,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Shahid12523 and pallavi_r for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar