Power BI

Needs Votes

PostgreSQL direct query

Vote (136)

Vitali Kaiser on 27 Apr 2017 14:14:59

Support of the PostgreSQL database as direct query. At the moment only import is supported.

Comments (20)

Comments (20)

Franck on 06 Jul 2020 00:04:22

RE: PostgreSQL direct query

'+ 1

Zachary Sloane on 06 Jul 2020 00:00:16

RE: PostgreSQL direct query

DirectQuery PostgreSQL is supported by the native connector from Power BI Service. It is not supported from Report Server. I have added another idea specific to Report Server (on-prem Power BI).

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38761357-postgresql-directquery-support-on-report-server

Scott Goley on 05 Jul 2020 23:46:25

RE: PostgreSQL direct query

I'm working on a Custom Connector that will work for Direct Query from PostgreSQL through an ODBC driver. Working on a full write-up (this month when I get time) but until then I can just share the repo here:

https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI

This is working for us to DirectQuery our Postgres data source via an Azure hosted Windows instance running the custom connector on a On-Premise gateway 24/7.

Power BI User on 05 Jul 2020 23:40:37

RE: PostgreSQL direct query

We need this as well!

David Dykstra on 05 Jul 2020 23:37:12

RE: PostgreSQL direct query

'+5

Power BI User on 05 Jul 2020 23:37:05

RE: PostgreSQL direct query

No direct queries on PG? Pathetic! Do you really expect users to download billions of records to their desktop PC's? Or did you release this product before it was ready? Other BI tools aren't this limited in connectivity.

Power BI User on 05 Jul 2020 23:34:36

RE: PostgreSQL direct query

'+1

Power BI User on 05 Jul 2020 23:30:03

RE: PostgreSQL direct query

This would be awesome.

Power BI User on 05 Jul 2020 23:30:02

RE: PostgreSQL direct query

PostgreSQL is becoming the go to open source relational database solution. Please support direct query.

Power BI User on 05 Jul 2020 23:30:02

RE: PostgreSQL direct query

'+1