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
- SQLite DB Migrations with PRAGMA user_version
- Edge Detection with Inkscape
- Lev Lazinskiy
- Spring Security, Webjars, and MIME type error
- Using cgit
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- Joining Cursor from Fatih Arslan
- Pluralistic: Digital sewer socialism (08 Aug 2026) from Pluralistic: Daily links from Cory Doctorow
- Pluralistic: Enshittification and Reverse Centaurs go global (29 Jul 2026) from Pluralistic: Daily links from Cory Doctorow
- AI Mania Is Eviscerating Global Decision-Making from Ludicity
- No-One Escapes the Permanent Underclass from Fernando Borretti
- Is it ethical to use AI? from charity.wtf
- The logical destination of LLMs from Andy Bell
- Revised rules of engineering leadership. from Irrational Exuberance
Articles from blogs I follow around the net
Qwen 3.8 27B is excellent, but it defaults to wildly overthinking things
Friday's big release was Qwen 3.8 27B, an Apache 2 licensed 27B parameter vision-capable LLM from Alibaba's Qwen research lab. I've been looking forward to this one: 27B is an excellent size for running a model on a reasonably specced laptop, and its prede...
via Simon Willison's Weblog: Entries August 16, 2026“I think there’s a lot of value in these.”
Speaking of user interface guidelines, developer Matt Sephton and others compiled many of Apple’s human interface guidelines, starting from 1980, all the way to 2014, including some goodies like early drafts, NeXT, Newton, and so on. Elsewhere, designer Ge...
via Unsung August 16, 2026Birding photos from Dutch Gap on Aug 15, 2026
Birding photos from Dutch Gap on Aug 15, 2026 My best bird photo from this morning is a dragonfly (Eastern Pondhawk, I think). Least Sandpiper Green Heron Red-headed Woodpecker. It's a juvenile, so its head is not actually red yet.
via O'DonnellWeb August 16, 2026Generated by openring