Connection Problem - set 'sslmode' as 'require' in connection settings

Hi Miguel_Rojo 

It sounds like a network or authentication issue specific to Power BI Desktop rather than a credentials problem. Here are steps to troubleshoot and fix it:

1. Check Firewall & Network Restrictions

• If the Cloud Power Query (Dataflow) works but Power BI Desktop doesn’t, it could be a local network restriction.
• Try connecting from another network or VPN.
• Ensure port 80 is open for outbound connections in your Windows Firewall.

2. Update PostgreSQL Connector & Power BI Desktop

• Ensure you have the latest version of Power BI Desktop and PostgreSQL ODBC driver.
• Manually update the PostgreSQL driver from here.

3. Use Full Server Name & Port

• Instead of Host:80, try using: Server = full.server.name.com:80 OR Server = full.server.name.com
  Port = 80
  
  

4. Clear Cache & Re-enter Credentials

• Go to File → Options & Settings → Data Source Settings.
• Find your PostgreSQL connection and clear permissions.
• Re-enter the credentials.

5. Use Advanced Connection String

Try connecting using Advanced Options in Power Query:Host=full.server.name.com;Port=80;Database=AEP_prod;Username=UsernameExample;Password=YourPassword;SSL Mode=Require;

• Ensure SSL Mode is correctly set based on your server.

6. Check Logs for More Details

• In Power BI Desktop, go to: File → Options & Settings → Diagnostics → Enable Tracing
• Retry the connection and check the log file for details.

If none of these steps work, check with your Cloud PostgreSQL admin if there have been any security changes or IP restrictions applied recently.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube