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. 

Anonymous's avatar
Anonymous
Not applicable
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.