Power BI

Needs Votes

Implement Live/DirectQuery for Postgres

Vote (174)

Vincent Kok on 26 Sep 2017 15:53:52

Currently only scheduled refreshes are possible.

Please enable DirectQuery for Postgres in Enterprise and Personal Gateways so we can leverage Postgres db's running on Azure.

Thank you.

Comments (14)

Comments (14)

umut aydoğdu on 06 Jul 2020 00:10:19

RE: Implement Live/DirectQuery for Postgres

Please add functionality for getting timescaledb data into powerbi.
Thank you

Bob L on 05 Jul 2020 23:59:08

RE: Implement Live/DirectQuery for Postgres

When this connector is added to Power BI service and gateway, can it be done in a way to support SSO / Kerberos when performing DirectQuery queries?

https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-overview

https://www.postgresql.org/docs/10/auth-methods.html

Eugene on 05 Jul 2020 23:58:54

RE: Implement Live/DirectQuery for Postgres

PostreSQL Direct Query is not working in Power BI Service though it's working just fine in Power BI desktop. What the purpose of not having it enabled on Services?

When PBS will support PostreSQL Direct Query?

Romuald on 05 Jul 2020 23:58:04

RE: Implement Live/DirectQuery for Postgres

It is very disappointing that PostreSQL Direct Query is not working in Power BI Service. I tried to use it and got "DirectQuery may not be used with this data source". What is the purpose of announcing the feature which in fact is not working...

Kevin H on 05 Jul 2020 23:57:26

RE: Implement Live/DirectQuery for Postgres

It seems this was included in the August 2019 Power BI Desktop release. But I tried it and it doesn't yet work in the Power BI Service, with an On-Premises Data Gateway.

A tech from Power BI support confirmed it is not supported in the Service. At least not yet. Need it to work in the Service with a Gateway, please!

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

RE: Implement Live/DirectQuery for Postgres

This is a very useful feature request. As many huge companies are using PostgreSQL in their infrastructure, it should be possible.

Bruno on 05 Jul 2020 23:49:59

RE: Implement Live/DirectQuery for Postgres

Any updates on this? Is very disappointing not supporting live queries for PG. Tableau supports this, Cognos supports this, ThoughtSpots supports this,.....everyone supports this, except PBI. Why you guys do not want to support it?

Andreea on 05 Jul 2020 23:49:57

RE: Implement Live/DirectQuery for Postgres

Do you have any news as to a possible date where this enhancement can be done, please? Is it already part of your roadmap? Do you have any timelines? I would really appreciate your answer on this.

Giovanni Miraglia on 05 Jul 2020 23:48:23

RE: Implement Live/DirectQuery for Postgres

any update on this?

Scott Goley on 05 Jul 2020 23:48:11

RE: Implement Live/DirectQuery for Postgres

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 (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 an On-Premise gateway 24/7.

My contact details are available on the repo for more info.

Edit: Post now available on my website @ https://medium.com/just-readr-the-instructions/directquery-with-postgres-from-powerbi-desktop-f3d8c4dc5e15