Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

@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/

 

 

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.
amitchandak
Super User
Super User

@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/

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.