How do I connect excel powerquery to a postgres database

Question

I need to connect powerquery to a postgres database in order to clean and have automated access to the data for excel reports.

I've tried: Get Data - From Database - From PostgreSQL database

This tells me I need npgsql, which takes me to github. However I'm not sure how to install that from github. I downloaded the zip file but I don't know what to do to install it on my computer.

I've also searched google and youtube, which I thought would definitely give me the answer, but no luck so far.

Could you provide more information? NpgSQL should already be part of your Powerquery install (unless you installed Power BI before 2019). Then you will also need to use a gateway. — Elvino Michel
– Elvino Michel, Commented Feb 26, 2024 at 16:05

stb · Accepted Answer · 2024-05-17 08:35:59Z

0

You need to install msi package of Npgsql which installs npgsql assemblies to GAC. Currently (2024-05-17) this seems to be the latest release of npgsql with such an msi package:

https://github.com/npgsql/npgsql/releases/tag/v4.0.13 (2022-06-19)

points to https://github.com/npgsql/npgsql/releases/download/v4.0.13/Npgsql-4.0.13.msi

Please make sure to enable GAC option in installer.

Documentation: https://www.npgsql.org/doc/installation.html#windows-msi-installer

answered May 17, 2024 at 8:35

stb

8906 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I connect excel powerquery to a postgres database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related