Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Make sure Postgresql is SSL enabled

You have installed the latest version of https://github.com/npgsql/Npgsql/releases

and also you need to register SSL certificate with windows. Only then  postgresql will work and Direct queru will work with postgresql connector