cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vmbruno
New Member

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 6
nusairi
Frequent Visitor

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.


 

sguenther
Advocate II
Advocate II

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.

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 .

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 Smiley Happy

 

 

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?

Having same problem. @felipetancredo and @vmbruno did you solve it? 

 

Any help is much appreciated.

 

Thanks,

indhu

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors