Using Microsoft Power BI With PostgreSQL
Microsoft Power BI is an advanced business intelligence suite that allows you to perform robust data analysis from a variety of different data sources. One common data source is PostgreSQL. Although Microsoft PowerBI does support PostgreSQL, getting started can be a bit tricky because there is no great documentation.
If you try to connect to PostgreSQL with a fresh installation of PowerBI you will receive the following error message.
This connector requires one or more additional components to be installed before it can be used.If you click on the Learn more link, it will take you to the GitHub repository for the Npgsql library, which is a windows driver for Postgres.
If you download the latest .msi file and run through the default installation, you will continue to receive the same error message in Power BI. In order to get this to work you must select the Npgsql GAC Installation option as shown in the screenshot below.
Once you have installed the Npgsql GAC Installation, you can restart Microsoft Power BI and you should now be able to connect to a PostgreSQL database as a data source.
[caption id=“attachment_682” align=“alignnone” width=“640”]
PostgreSQL connection window in Microsoft Power BI[/caption]
Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.
Check out some more stuff to read down below.
Most popular posts this month
- 2025
- Ladybird on Debian Stable
- My Custom Miniflux CSS Theme
- Setting up ANTLR4 on Windows
- SQLite DB Migrations with PRAGMA user_version
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- Pluralistic: bunnie's piggyback hack (09 Jan 2026) from Pluralistic: Daily links from Cory Doctorow
- Clicks Communicator from Chris Hannah
- A Year Of Vibes from Armin Ronacher's Thoughts and Writings
- Pluralistic: A perfect distillation of the social uselessness of finance (18 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
- Moving from WordPress to Substack from charity.wtf
- Grow, Like a Tree Not a Cancer from Jim Nielsen’s Blog
- Pluralistic: All the books I reviewed in 2025 (02 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
- DEP-18: A proposal for Git-based collaboration in Debian from Optimized by Otto
Articles from blogs I follow around the net
Go Read a Book
There's a lot of shitty news happening lately, and I've been having trouble holding space for it all.
via flower.codes January 24, 2026ROSCon Korea 2026 Review
After attending my first ever ROSCon in Singapore 3 months ago, I had a chance to participate in the first ever regional ROSCon in (South) Korea! Physical AI is here I had an interesting discussion with a team lead at ROBOTIS, a major Robotics company , o…
via Junwoo Hwang January 24, 2026[RIDGELINE] Eras
Ridgeline subscribers — I like “eras.” That is, named chunks of time. Japanese history tends to periodicize based on locus of power. The Tokugawa Shogunate reigned for hundreds of years, and so: Edo, where the power was, becomes the period (a big sweeping o…
via Craig Mod — Writer + Photographer January 24, 2026Generated by openring