cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdaoudi
Regular Visitor

Can't connect to postgresql database (Linux server on the cloud)

Recentlu we had to migrate our local linux server to the cloud, the data was refreshed through a gateway installed on a Windows Server wich has access to the database, and now I'm trying to change the datasource, it's working on Power BI Desktop but the refresh fails on Power BI service, I get the following error:

 

Failed to update data source credentials: The PostgreSQL source doesn't support encrypted connections

 

I tried to uncheck the encryption connection option

I tried to configure an ODBC connection on Windows and access data through the gateway.

Any help or Ideas?

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

@bdaoudi , PostgreSQL should be SSL enabled.

You need to download the certificate and import it into windows.

You also need the latest driver: https://www.nuget.org/packages/Npgsql/6.0.0-preview3

 

Also, make sure you have access to database on the machine using pgadmin

 

refer for detailed steps

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

v-shex-msft
Community Support
Community Support

HI @bdaoudi,

Have you added the SSL certificate to the device installed the power bi gateway client for your data connection?

In addition, please check the configuration folder of the PostgreSQL server to confirm SSL settings are correctly configured.

BTW, you can also take a look at the following link about power bi service white lists if they blocked by device policy/configurations.

Add Power BI URLs to allow list - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @bdaoudi,

Have you added the SSL certificate to the device installed the power bi gateway client for your data connection?

In addition, please check the configuration folder of the PostgreSQL server to confirm SSL settings are correctly configured.

BTW, you can also take a look at the following link about power bi service white lists if they blocked by device policy/configurations.

Add Power BI URLs to allow list - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

amitchandak
Super User IV
Super User IV

@bdaoudi , PostgreSQL should be SSL enabled.

You need to download the certificate and import it into windows.

You also need the latest driver: https://www.nuget.org/packages/Npgsql/6.0.0-preview3

 

Also, make sure you have access to database on the machine using pgadmin

 

refer for detailed steps

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors