问题描述
我正在尝试将 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 andadd 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/
这篇关于从提供程序读取数据时发生错误.根据验证程序,远程证书无效的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!