安装 ngpsql 以在 PowerBI 中使用 PostgreSQL [英] Installing ngpsql to use PostgreSQL in PowerBI

问题描述

我正在尝试将 PostgreSQL 数据库中的数据导入 PowerBI Desktop，但它似乎不起作用.我认为问题在于使用 npgsql 进行安装.尝试在 PowerBI 中设置新的数据库连接时，我输入了数据库和服务器，这是我收到的错误消息:

I'm trying to get data from a PostgreSQL database into PowerBI Desktop but it doesn't seem to work. I think the problem is with the installation with npgsql. When trying to setup a new database connection in PowerBI I type in the database and server, and this is the error message I get:

"无法连接详细信息:PostgreSQL:我们无法找到具有不变名称Npgsql"的数据库提供程序.此错误可能是由于需要特定于提供商的客户端软件而导致的，但在此计算机上没有.要为此提供程序下载客户端软件，请访问以下站点并选择至少 64 位 (x64) 版本的Npgsql 版本 2.0.12":https://go.microsoft.com/fwlink/?LinkID=282716""

"Unable to connect Details: "PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716""

我已尝试访问 npgsql 网站并安装所需的组件，但似乎无法使其正常工作.我不是开发人员，所以这对我来说有点复杂.有谁知道如何安装这些组件?我非常感谢您的帮助！

I've tried going npgsql website and install the required components but I can't seem to get it working. I'm not a developer so this is a bit complicated for me. Does anyone know how to get these components installed? I very much appreciate your help!

如果有帮助，我将在 Surface Pro 3 上使用 Windows 10.而且我也安装了 Visual Studio Community.

I'm using Windows 10 on a Surface Pro 3 if this helps. And I do have Visual Studio Community installed as well.

最好的，布鲁诺.

推荐答案

我已经下载并试用了3.6.6版本

I have downloaded and tried it with version 3.6.6

1. 安装 npgsql
2. 在安装阶段，启用Npgsql GAC 安装"，因为 GAC 需要 Npgsql.
3. 重启电脑.

它现在应该可以工作了.

It should work now.

这篇关于安装 ngpsql 以在 PowerBI 中使用 PostgreSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！