Forum Discussion

New Member

10 years ago

Connect PowerBI Desktop with PostgreSQL

I'm tring to connect power BI to a Posgres 9.4 database installed into the same machine (my windows 10 laptop). I've overcome the error about Npgsql intalling Npgsql.dll with GACutil and modifying t...

BlancaHernandez

New Member

10 years ago

Hi,

I have faced exaclty the same problem and I tried to set up Postgres as the documentation explains, but I get still the same message, any hints?

Thanks!

mfairchild
New Member
10 years ago
Im also having the same problem. hopefull
- ashishrj
  Power Participant
  10 years ago
  mfairchild This blog in Power BI Community might help click here
  - mfairchild
    New Member
    10 years ago
    Thanks for that link ashishrj. I was actually trying to connect excel to postgres, and from there export to Power BI.
    The doc at https://support.office.com/en-za/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4?ui=en-US&rs=en-ZA&ad=ZA seems straight forward, except its not clear how to specify additional options for the Npgsql driver. Plenty are mentioed at http://www.npgsql.org/doc/connection-string-parameters.html. I need to set the `Trust Server Certificate=true` value. The dialog in excel does not seem to offer fields for raw connection string tho. Any ideas how to specify more details, or jsut provide a raw connection string?

Related content