Forum Discussion
Cannot connect Power Bi Service to PostgreSQL hosted in Azure
Hi Anonymous ,
Sorry for my lose. We have submitted to internal icm 311546402 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.
Best Regards,
Community Support Team _ Caitlyn
Hi Anonymous ,
The PostgresSQL connector doesn't work out of the box, you need to do quite a few things first
1. Install Npgsql which allows .NET access to PostgresSQL. I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/
You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)
2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)
4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
5. Test access from Power BI desktop using the PostgresSQL connector and it should work
This was resolved after following the steps below ( Original link on - https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS... )
Please check if it helps.
Best Regards,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Caitlyn
Thank you for your message
I totally understand what you are saying, its just that our PostgreSQL is hosted in Azure not AWS. And as you know when hosting in Azure there is no need for a data gateway to connect from Power bi service to the DB.
And we have been working like this with no issues for the past 6 months.
It looks like suddenly PowerBI service has upgraded their version of npgsql