Postgresql SSL Issues

[johnsquared]

Hi,

I am struggling to get my report refreshing on the live service. It works perfectly in desktop.

I am hosting a postgresql database on a remote linux server.

When attempting to refresh I used to get this error. The PostgreSQL source doesn't support encrypted connections.

I tried to use a self signed SSL certificate and now I am getting this error. The remote certificate is invalid according to the validation procedure.

On a side note I am hosting a website using letsencrypt SSL that works perfectly fine, can I somehow use the certificate for that website for my database as well?

Any help will be much appreciated. 

[johnsquared · Accepted solution]

None of the solutions I looked up including the one above worked but I did get it resolved.

Firstly you need to host a website on the same remote server. 

Then use letsencrypt to create ssl certificate for it.

Reuse the same certificates and point to them in your postgres install - you will need ensure the permission are correct. If using a docker container then include the folder of the certificates in your volume.

Connect in Power Bi using yourdomain.com:5432 instead of the server IP.
Then everything works as intended 🙂

[v-yinliw-msft]

Hi @johnsquared ,

I think you can refer this thread, they had the same question with you.

There is a complete solution process inside:

Solved: The remote certificate is invalid according to the... - Microsoft Power BI Community

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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

[johnsquared]

Bump