Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.