Postgres conection

[dzerain]

Me sale el siguiente problema cuando pongo el IP y BD en el conector de Postgres:

Detalles: "Se produjo un error al leer datos desde el proveedor: 'Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder'"

Mi BD esta en la nube en un servidor de azure. Ya abri el firewall para revisar la conexión, y aún nada.

[Shahid12523 · Accepted solution]

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.

[v-pgoloju]

Hi @dzerain,

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

[v-pgoloju]

Hi @dzerain.

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

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

[pallavi_r · Accepted solution]

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

[Shahid12523 · Accepted solution]

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.