Forum Discussion

ecate's avatar
ecate
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...
Need Help
kschaefers's avatar
kschaefers
Resolver I
9 years ago

michaeldurieux, thanks a lot for this detailed description. However, it still does not work for me.

I am getting the following error message:

 

I am connecting to our AWS database through a tunnel which uses port 10001 on my machine. So in the connection settings I tried 127.0.0.1 (works e.g. in HeidiSQL) or localhost:10001. But neither of those work :(

kschaefers's avatar
kschaefers
Resolver I
9 years ago

Okay, this just got even worse :).

 

I reinstalled the latest npgsql version from here

https://github.com/npgsql/npgsql/releases

 

and now I am getting this message:

 

Why is this so difficult in Power BI?

 

I don't understand, why they even list PostgreSQL as an option, when you basically need an engineering degree to get it working :).