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

pulkitg123, thanks for your advice, but tihs is quite a challenge for non-developers. Maybe can you further elaborate on the steps? how exactly do I install openssl from the Google Library?

 

Also Microsoft, why aren't you providing more native working connections? Tableau has all of these working out of the box.

Cheers,

Konrad

michaeldurieux's avatar
michaeldurieux
Helper I
9 years ago

Maybe a more detailed view even if the post of @pulkitg123 seems to be enough.

 

My OS : Windows 2012 Server R2

My Database is stored on AWS. This is a PostGreSQL database using RDS AWS service.

 

 

  1. Download and install Npgsql (latest version from the official github repo : link here).
  2. Download the AWS RDS public certificate (certificate to download) on your desktop for instance.
  3. Download the last version of openssl (link here). Unzip the file on you desktop for instance - just keep in mind the link of openssl.exe which is in "bin" folder extracted. You we'll need it in step 4).
  4. Set OpenSSL to your PATH variable (See Youtube video here).
  5. Create a .crt file from the .pem file downloaded in step 1 : open a console on Windows (Win + R, then enter "cmd" and OK) and past this following line in your console (openssl x509 -outform der -in rds-combined-ca-bundle.pem -out rds-combined-ca-bundle.crt). Do not forget to indicate the PATH of your AWS RDS public certificate downloaded on step 1 (rds-combined-ca-bundle.pem)
  6. Install the certificate from the newly created (.crt) file. (Just follow these steps)
  7. Reboot your computer :-)
  8. Connect!
  • 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