Implement Live/DirectQuery for Postgres
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.
Bob L commented
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?
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?
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 commented
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!
This is a very useful feature request. As many huge companies are using PostgreSQL in their infrastructure, it should be possible.
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?
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.
any update on this?
Scott Goley commented
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:
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://justreadrtheinstructions.com/post/2019-06-15-directquery-postgres-howto/
Please add live query, with support for direct (non-gateway) connections
Please make adaptation to allow Postgres to automatically refresh data in power bi without a gateway.
Zach Anderson commented
The ability to quickly add Azure DB's would be nice, but I'd also like to see non-Azure Postgres connectivity for the web version of PowerBI
Please include Live Connections (https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about) with DirectQuery support as we have a need for each user to enter their Postgres username/password when querying.