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)
RE: Implement Live/DirectQuery for Postgres
Please add functionality for getting timescaledb data into powerbi.
Thank you
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
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?
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...
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!
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.
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?
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.
RE: Implement Live/DirectQuery for Postgres
any update on this?
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