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 the file machine.config.However now I've the following error:"Ssl connection requested. No Ssl enabled connection from this host is configured."Why a ssl connection is required?Can I force Power BI not to use ssl?Or is that a problem with Postgres and I have to configure it differenly?Does Anyone fixed it?Thanks!

Hi to everyone, I've faced the same issue and I've found the solution thanks to arify.1) Install the latest release of Npgsql (by now the 3.0.5 version -> Npgsql-3.0.5.msi and Setup_NpgsqlDdexProvider.exe)2) Restart the pc If you try to access into the database it might give you this error: But if you follow the indications provided by arify you can solve this problem. 3) You have to enter in the "Data source settings" 4) and then edit the "Encryption" option. p.s. For Npgsql I provide the installers instead of the .zip because it's more easy to use. #I'M Not An Expert#

Hi everyone, Npgsql drivers have a different behavior in the last few months' versions, that's why this is happening. We're fixing this now, it'll be in PBI releases in the next few months. For the workaround, you can change the encryption setting of your database credential: Sorry about the inconvenience and thanks for reporting this to us!Oguz

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.

Hi everyone, we still can't natively establish a connection with a PostgreSQL databyse. Any plans on including a fix in one of the next versions? it works out of the box btw. in tableau ;)

IF you are using AWS hosted Postgre then use the public key certificate provided by AWS. Please follow the following instruction after installing Npgsql latest version Download the AWS RDS public certificate (https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem)use Google library to install openssl(https://code.google.com/archive/p/openssl-for-windows/downloads) and set it to path variable.(http://stackoverflow.com/questions/11896304/openssl-is-not-recognized-as-an-internal-or-external-command)To Create a .crt file from the .pem file downloaded. use this in command line (openssl x509 -outform der -in rds-combined-ca-bundle.pem -out rds-combined-ca-bundle.crt)Install the certificate from the newly created (.crt) file.(http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm)Connect!