Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
karen578
Helper I
Helper I

npgsql data provider to import postresql data in Excel

Hi, I'm trying to import postgresql data through Power Query in Excel.

 

When I try to set it up in Excel, it takes me to this Microsoft page (Import data from data sources (Power Query) - Microsoft Support) telling me I need an npgsql data provider installed.

 

I've gone to the official documentation for npgsql here Installation | Npgsql Documentation and it's very unclear to me how to use it. Recent version downloads include a bunch of code with no installer file.

 

I was able to find this recent (2024) Microsoft page (Power Query PostgreSQL connector - Power Query | Microsoft Learn) specifically specifying the need for version 4.0.10. Is that still the case? On the npgsql site, it says this is now out of support. The download is still available and has an msi installer file (which is what I was expecting to need for this), but here's a quote from the npgsql site: "Do not use the Windows MSI installer unless you're sure that your program requires GAC installation - this method is otherwise highly discouraged."

 

I'm out of my depth technically on this one. I haven't been able to get IT help and I don't have admin rights to install anything myself, so I can't easily try a bunch of things. I've found some forum posts mentioning npgsql but they're all a few years old.  Is anyone able to confirm if 4.0 is still a requirement? Or if a later version works, how do I get it to work with Power Query?

 

Thanks!!

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

yes. 4.0.10 is still a requirement. Newer versions are not working.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

yes. 4.0.10 is still a requirement. Newer versions are not working.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors