Forum Discussion
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?
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/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
2 Replies
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/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