Forum Discussion
Connect PowerBI Desktop with PostgreSQL
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
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.
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?
(If you can find a PostgreSQL ODBC driver, you can specify the flag in the connection string that would help allow the certificate exceptions.)
Hi arify, it's just a normal PostgreSQL database. I will try the ODBC driver version.
How do I set up an ODBC driver?