Forum Discussion
Power BI Desktop ODBC Connectors to PostgreSQL with Direct Query Enabled
Greetings, I'm trying to set up Power BI Embedded with a web page. I am using Postgres and I need to use Direct Query due to the size and volume of data. I have understood achieving this I must, cre...
I managed to resolve this, for anyone in 2020 reading this, you do not require an ODBC connector to use an On-premise data gateway, the docs say it is not supported anyway. I used the standard Postgres Connector offered out the box, I installed this driver here:
Release Npgsql v4.0.10 · npgsql/npgsql · GitHub
I used the GAC method and everything worked. There is a number of old posts saying you need an ODBC driver or a customer connector and it's false, in my experience.
amitchandak Thank you for responding, yes I have Npgsql installed, and I am currently working my way through an SSL install and will try it again, I'll update when I have tested everything and got it installed.