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

[Miguel_Rojo]

Hi community,

I'd like to put forward a connection problem  when trying to connect to a "Cloud PostgreSQL database" in my power query desktop file. 

I proceed to describe the scenario, hopping you could provide any insights.

Scenario:

• During the past 6 months I was able to succesffully connect my desktop file to a cloud "prod:all" database in my Power Bi desktop file.
• I generated the required creddentials in the production environment, and successfully use them:
  • Server: Host:80
  • Database: AEP_prod:all
  • User Name: UsernameExample
  • Passsword: TechnicalAccountId:Password
• The thing is that, since past week, the very same credentials triggered the next error

Now, I'm unable of execute any refresh or stablish a connction with my credentals. 

The fun fact, is that those very same credentials used in a Power Bi "dataflow" works sucessfully; I don't understand how "Cloud Power Query" allows this scenario and "Local Power Query" not.

Do you know what can be done to fix my problem, and be able to connect via desktop file?

Important note: I don't need to use a "gateaway" since the Adobe Expierence Platform of Adobe, provides a cloud PostgreSQL database

[v-karpurapud]

Hi @Miguel_Rojo 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @Miguel_Rojo 

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank You!

[Miguel_Rojo]

Hi @v-karpurapud ,

Thanks for the follow up.

The issue has not been resolved.

As suggested in past threads, I made the next actions trying to fix it:

• install postgrsql drivers on windows for odbc powerbi
• Use Full Server Name & Port
• Clear Cache & Re-enter Credentials

I continue with a workaround for this issue (use Dataflow instead "local Power Query").

But I think that i'll need to contact the Adobe team support to address this issue.

Thanks,

Miguel

[v-karpurapud]

Hi @Miguel_Rojo 

Reaching out to Adobe's support team is the best way to address this. They have the expertise to help you resolve the issue quickly and efficiently.

Thank You!

[Anonymous]

Hi @Miguel_Rojo ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[VahidDM]

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