从提供程序读取数据时发生错误。根据验证步骤，远程证书无效 [英] An error happened while reading data from the provider. The remote certificate is invalid according to the validation procedure

问题描述

我正在尝试将AWS EC2实例上的Postgres数据库连接到Microsoft PowerBI。我尝试了Internet上可用的各种方法，但显示了上述错误。尽管我已经在AWS RDS上完成了此连接。我安装了必需的依赖项（GAC）和PowerBI所需的所有证书。

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.

推荐答案

我遇到了同样的问题，很遗憾，我没有找到解决问题的方法。但是我找到了替代方法。

I've came across the same issue, unfortunately I didn't find solution to resolve it. But I found an alternative.

您可以使用ODBC连接来连接PostgreSQL。

You can connect PostgreSQL using ODBC Connection.

为PostgreSQL设置ODBC：< a href = https://www.postgresql.org/ftp/odbc/versions/msi/ rel = nofollow noreferrer> https://www.postgresql.org/ftp/odbc/versions/msi/

Setup ODBC for PostgreSQL: https://www.postgresql.org/ftp/odbc/versions/msi/

安装后，在获取数据下选择ODBC连接

After Installation, Select ODBC Connection under "Get Data"

在数据源下选择无名称和
在连接字符串下添加以下语句：

Select "None" under Data Source Name and add following statement under connection string:

Driver={PostgreSQL ANSI(x64)};Server=<host>;Port=5432;Database=<dbname>

单击下一步

输入用户名和密码，单击连接。
如果凭据正确，您将看到数据库中可用表的列表。

Enter Username and Password, Click Connect. If credentials are correct, you will see list of tables available in database.

请遵循此参考以获取详细说明：
> http://niftit.com/connecting-power-bi-to-postgresql/

Follow this reference for detailed description: http://niftit.com/connecting-power-bi-to-postgresql/

这篇关于从提供程序读取数据时发生错误。根据验证步骤，远程证书无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！