- Download and install Npgsql (latest version from the official github repo : link here).
- Download the AWS RDS public certificate (certificate to download) on your desktop for instance.
- 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).
- Set OpenSSL to your PATH variable (See Youtube video here).
- 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)
- Install the certificate from the newly created (.crt) file. (Just follow these steps)
- Reboot your computer :-)
- Connect!
Forum Discussion
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...
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
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.