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

BTW, connection with PostgreSQL works beautifully in Tableau... not additional setup. Just works out of the box!!

arify's avatar
arify
Microsoft Employee
9 years ago

Hi kschaefers, do you get the certificate error too? Does your server need a specific certificate, or do you just need PBI to allow trusting the untrusted Server Certificate or allow a name mismatch etc. ?

 

Thanks

  • kschaefers's avatar
    kschaefers
    Resolver I
    9 years ago

    Hi arify, Yes exactly the same. I'm accessing our PostgreSQL database on Amazon AWS through a secure tunnel (Company policy). Therefore the server address is a local IP address like 127.0.0.1 port 5432. I added the PostgreSQL certificates but that doesn't make a difference probably cause I can't use the same server name (I have to use the IP address as mentioned above).

     

    I think allowing PBI to trust the untrusted Server Certificate would work.

     

    I don't understand why it's so hard to set this up in Power BI compared to Tableau?! With Tableau I didn't even have to download any additional driver.  For PowerBI I had to download some strange .msi file from github, need administrator rights to install it (requires a request at our IT department). I had similar problems connecting to our EXAsol database. Again, worked out of the box with Tablea and simply couldn't get it to work in PBI, though that is probably a topic for another thread.

     

     

    • arify's avatar
      arify
      Microsoft Employee
      9 years ago

      Tableau might have an embedded driver in their product, I wouldn't know. About the certificate usage, it's on our radar and we're working on making the "allow exceptions" logic usable in PBI. But right now unfortunately it's not supported.

       

      I want to give you a possible work around, is this an Amazon Redshift database, or just a normal PostgreSQL?

      • arify's avatar
        arify
        Microsoft Employee
        9 years ago

        (If you can find a PostgreSQL ODBC driver, you can specify the flag in the connection string that would help allow the certificate exceptions.)