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

amitchandak I have the latest version of npgsql and have established an ODBC connection with the SSL installed. I have tried online with other forums and this area seems to be largely undocumented and very difficult to do/work out. The problem with the Power BI ODBC it does not allow for Direct Query access.

 

Here're the steps I have taken thus far:

  • Created a DSN in Windows with the Postgres UNICODE 64x driver
  • Created the relevant SSL certs as per official docs
  • Used an ODBC data source, select the DSN I want to use and then no Direct Query option works.