Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
When using Power BI, occasionally a graph or chart does not load (can’t display the visual) with the error OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream.
Hi all,
We are using PostgreSQL as a data source and Power BI connects to it via PGBouncer. After looking at PGBouncer logs and searching for similar issues, I’ve discovered that there are certain issues with Npgsql (a .NET driver for PostgreSQL, which I assume is being used by Power BI under the hood) and PGBouncer. The Github issue is https://github.com/pgbouncer/pgbouncer/issues/714. And the documentation for PGBouncer issues can be found in https://www.npgsql.org/doc/compatibility.html#pgbouncer.
From the documentation and the linked Github issue, a solution to this could be disabling Npgsql’s internal pooling. However, I have not been able to figure how to do this via Power BI connection settings.
Please advise me on the same.
Thanks
@abhishekjangid , There are three things needed including the certification, do not miss anu
PostgreSQL
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 51 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 135 | |
| 110 | |
| 50 | |
| 31 | |
| 29 |