Forum Discussion
PostgreSQL direct query - AWS with a data gateway
I haven't found quite the answer I'm looking for, but sorry if I've missed it.
This thread from last year suggests what I want to do is not yet available:
https://community.powerbi.com/t5/Desktop/Direct-Query-for-PostgreSQL/m-p/776979
But this page from March 2020 indicates it is:
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
However, I haven't found any reports that this is indeed working, and my worry is that page from March actually means Azure PostgreSQL (rather than any PostgreSQL). My PostgreSQL database is hosted on AWS, so needs to connect via a data gateway. This is working fine with an ODBC connection currently, but only with scheduled data updates.
Is anyone able to confirm that direct query is available for PosgreSQL databases that are not on Azure? If so I'll go down the (somewhat challending sounding?) path of Npgsql drivers, if that is indeed the path forward.
1 Reply
tenmile , You have to install this NpgSQL latest version
You have to get and install the certificate, make sure you do this step correct otherwise this will not work
https://community.powerbi.com/t5/Desktop/Connector-Postgre-SQL-DATABASE/td-p/195104
or
https://docs.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security
