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

windows postgresql amazon-ec2 powerbi
Mr.Robot picture Mr.Robot · Dec 25, 2018 · Viewed 7.7k times · Source

I'm trying to connect Postgres Database on AWS EC2 instance to Microsoft PowerBI. I tried various method available on internet but its showing the above error. Although I've done this connection on AWS RDS. I installed required dependencies (GAC) and all the certificates required for PowerBI.enter image description here

Answer

Neil picture Neil · Feb 28, 2020

Following worked for me:

File / Options and settings / Data source settings

then select data source

and Edit Permissions and uncheck encrypt connections

Related questions

How do I enable php to work with postgresql?

<?php try { $dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##'); echo "PDO connection object created"; } catch(PDOException $e) { echo $e->getMessage(); } ?> I get the error message "Could Not Load Driver"

Read More
good postgresql client for windows?

coming back to postgresql after several years of oracle ... what are the state-of-the art postgresql administrative/ddl generating/data inserting frontends on windows? it would be nice if it had integration for postgis as well. it should be standalone or …

Read More
How to Allow Remote Access to PostgreSQL database

I have PostgreSQL 9.2 Installed in Windows 7 and I have windows XP installed in Virtual Machine, how do I connect these two databases and allow remote access to add/edit the database from both Systems ?

Read More