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
- mike96New MemberPlease 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.
- zacha1New MemberThe 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
- gabrijelNew MemberPlease make adaptation to allow Postgres to automatically refresh data in power bi without a gateway.
- Giovanni_MiraglNew Memberany update on this?
- layusoNew MemberPlease add live query, with support for direct (non-gateway) connections
- fbcideas_migusrNew MemberI'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
- andreeapeleaNew MemberDo 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.
- b_bruziniNew MemberAny 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?
- dubravko_dolicNew MemberThis is a very useful feature request. As many huge companies are using PostgreSQL in their infrastructure, it should be possible.
- kevhav1New MemberIt 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!
Recent ideas
Allow report creators to download their Own PBIX even when Downloads are restricted at tenant level.
In the current Power BI permission model, PBIX downloads are controlled exclusively through tenant‑level export settings and workspace roles. This creates a significant limitation for multi‑agency or...pbiuserNC6 hours agoNew MemberNew9Views0likes0CommentsNative KPI Governance, Ownership and Business Change Impact in Microsoft Fabric
Native KPI Governance, Ownership and Business Change Impact in Microsoft Fabric Idea In enterprise analytics, one of the biggest challenges is not creating a KPI, but ensuring that everyone agrees ...kulkarnigauri310 hours agoNew MemberNew4Views0likes0CommentsEnable writing PowerQuery type time (from Dataflow Gen2) to Warehouse type time
Currently the UI throws an error while I am trying to write Data typed as "time" in Power Query to a Fabric Warehouse. I would prefer to import data typed as "time" in Dataflow Gen2 PowerQue...pyd4life13 hours agoAdvocate INew105Views2likes1Comment