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 :).

 

 

  • michaeldurieux's avatar
    michaeldurieux
    Helper I
    9 years ago

    Could you try to reinstall npgsql with ticking the two options during the setup (and then reboot your PC) ?

     

    Let us know.

    Cheers.

    Michaël

      • michaeldurieux's avatar
        michaeldurieux
        Helper I
        9 years ago

        Sorry I didn't have any other idea.

        I had the same message because when I installed this driver for the first time, I didn't tick the two components during the setup.

        After uninstalling the driver and reinstalled-it and ticking the two components suggested (the second one - "NGGSQL GAC Installation" - is not ticked by default).

        I rebooted my computer and it works.

        I have no other idea.

        Maybe you can try a third time :-)