Power BI

Needs Votes

PostgreSQL direct query

Vote (135)

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)

17d46db4 a2c2-405f-8890-abadadeba0eb on 06 Jul 2020 00:04:22

RE: PostgreSQL direct query

'+ 1

1c21f6e0 1cab-4747-9639-19aca27e37f2 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

c181bfdc 8aa7-4c1f-adf6-37f199ac50af 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.

95697da6 d228-4cea-8c68-5914914d0c3d on 05 Jul 2020 23:40:37

RE: PostgreSQL direct query

We need this as well!

a5d9b7a3 96d1-49eb-a7ab-5e2e0f3f30a5 on 05 Jul 2020 23:37:12

RE: PostgreSQL direct query

'+5

bde54d0e e220-46d2-a4fe-9f41cc10d95f 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.