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.
15 Comments
- 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.
- 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 make adaptation to allow Postgres to automatically refresh data in power bi without a gateway.
- any update on this?
- Please add live query, with support for direct (non-gateway) connections
- 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
- 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 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?
- This is a very useful feature request. As many huge companies are using PostgreSQL in their infrastructure, it should be possible.
- 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!
