Power BI desktop - invalid certificate error when connecting to postgresql on azure

[WhyDuckk]

Hi,

I can't connect to a postgresql using native connector due to the following reason - 

Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"

Server is hosted on Azure. I want to pull the data to my local environment and then publish it to power bi service.

Everything works fine when I'm using odbc connection but it's not acceptable for my solution.
I've already tried turning off encryption parameter in power bi but it doesn't work.

Do you know any solution for that issue?

[Anonymous]

Hi, @WhyDuckk 

Please check out the following link, I hope it helps.

Solved: ERROR: The remote certificate is invalid according... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@WhyDuckk , There are 3-4 settings are required. Please make sure all are taken care

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/