How to Fix AWS PostgreSQL Certificate Errors in Power BI
Question details
Users encounter a connection failure due to an untrusted server certificate when trying to connect Power BI to an AWS-hosted PostgreSQL database.

- Product
- Power BI, AWS PostgreSQL
- Device & OS
- not provided
- Scenario
- Connecting Power BI desktop client to an AWS-hosted PostgreSQL database for data reporting.
- Observed behavior
- Power BI fails to establish a connection and displays an untrusted server certificate error.
Ensure you have administrator privileges on your Windows machine to import certificates and have downloaded the latest AWS RDS certificate bundle.
Import AWS RDS Certificate to Trusted Store
Establish a secure connection by importing the AWS RDS certificate chain into the Windows trusted certificate store used by Power BI.
Power BI relies on the underlying Windows certificate store to validate secure connections. If the AWS certificate chain is missing or not trusted, importing it manually will resolve the connection error.
Obtain the latest AWS RDS certificate bundle (such as a P7B or PEM file) from the official AWS documentation.
Press Windows Key + R, type 'certlm.msc', and press Enter to open the Local Machine Certificate Manager.
Navigate to 'Trusted Root Certification Authorities' > 'Certificates'. Right-click the folder, select 'All Tasks', and click 'Import'.
Follow the Certificate Import Wizard to browse and select your downloaded AWS certificate file, then complete the import process.
In Power BI, ensure the database server name matches the AWS endpoint exactly, then attempt the PostgreSQL connection again.

Manage Your Exported Data with WPS Office
While WPS Office cannot directly resolve Power BI database connection errors, it is the perfect free and lightweight alternative for managing, analyzing, and reporting on the data you export from your databases. Experience seamless compatibility with Microsoft Excel formats and a familiar user interface.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Exported Data: Launch WPS Spreadsheet and open any CSV or XLSX file exported from your database or Power BI.
- 3. Analyze and Report: Use pivot tables, charts, and formulas to analyze your data with full Excel compatibility.

Frequently Asked Questions
Why does Power BI reject my AWS PostgreSQL certificate?
Power BI uses the Windows Trusted Root Certification Authorities store by default. If the AWS RDS certificate chain is missing or outdated on your machine, Power BI will not trust the database connection.
How can I verify my database server name matches the certificate?
Check the endpoint URL provided in your AWS RDS console and ensure it matches the server name entered in the Power BI PostgreSQL connection dialog exactly. Mismatched names will trigger a certificate trust error.
Where can I download the correct AWS RDS certificates?
The official AWS RDS documentation provides regional and global certificate bundles in various formats, including P7B and PEM. Download the bundle that corresponds to your database region.
What should I do if the certificate error persists after importing?
Ensure you imported the certificate into the 'Local Machine' store rather than the 'Current User' store. If the issue continues, contact Power BI Support or your database administrator for further troubleshooting.




