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

问题描述

我正在尝试将 AWS EC2 实例上的 Postgres 数据库连接到 Microsoft PowerBI.我尝试了互联网上可用的各种方法，但它显示了上述错误.虽然我已经在 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: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屋！