Forum Discussion
Connect to PostgreSQL
Hi everybody!
I'm trying to get data from a PostgreSQL database but it doesn't seem to work. I think I miss some of the components that need to be installed. When trying to setup a new connection I type in the database and server, and this is the error message I get:
"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""
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! :)
I'm using Windows 10 on a Surface Pro 3 if this helps. And I do have Visual Studio Community installed as well.
Best,
Bruno.
6 Replies
Hey Bruno,
I was faced with the same problem and had to find the right installation files. What fixed it for me in the end was installing
Setup_Npgsql-2.2.4.3-net45.exe
Here is the link to the GitHub project:
https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3
Hope that helps.
Best
Sebastian
P.S.: Close your Excel and PowerBI Desktop during the installation. Otherwise you will run into a Token error.
Hi Sebastian,
Thanlk you so much for your reply! I went to that page and ran that .exe file. I think something has definitely improved since PowerBI no longer tells me of the missing files. However I still can't connect to the database. This is the error that I'm getting after I type in the server and database address :
"Unable to Connect
We encountered an error while trying to connect.
Details: "PostgreSQL: Failed to establish a connection to 'ec2-54-217-246-62.eu-west-1.compute.amazonaws.com'.""
Do you have any idea why this might be happening? In Excel I don't even get the PostgreSQL option when adding a new source. Could this be from the setup I installed was not fully compatible with my system/version?
Best,
Bruno :smileyhappy:
I'm getting the same problem:
PostgreSQL: Failed to establish a connection to 'xxxxxxxxxxx.us-west-2.rds.amazonaws.com'.
My Personal Gateway is installed on AWS west-2 region.
Any ideas?
Not sure why just this libs(https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3) has worked but not the lastest from npgsql.
Anyways thanks to sguenther .
THanks for the solution guys installing old version of npgsql seems to be working
https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3
vmbruno wrote:Hi everybody!
I'm trying to get data from a PostgreSQL database but it doesn't seem to work. I think I miss some of the components that need to be installed. When trying to setup a new connection I type in the database and server, and this is the error message I get:
"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""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! :)
I'm using Windows 10 on a Surface Pro 3 if this helps. And I do have Visual Studio Community installed as well.
Best,
Bruno.
