Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
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.
@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/
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.