Others

How to Fix AWS PostgreSQL Certificate Errors in Power BI

Ayan MasoodAyan Masood Nov 3, 2026 870 views

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.

How to Fix AWS PostgreSQL Certificate Errors in Power BI
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.
Before you start

Ensure you have administrator privileges on your Windows machine to import certificates and have downloaded the latest AWS RDS certificate bundle.

Solution 1Recommended

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.

1
Download the Certificate

Obtain the latest AWS RDS certificate bundle (such as a P7B or PEM file) from the official AWS documentation.

2
Open Certificate Manager

Press Windows Key + R, type 'certlm.msc', and press Enter to open the Local Machine Certificate Manager.

3
Import the Certificate

Navigate to 'Trusted Root Certification Authorities' > 'Certificates'. Right-click the folder, select 'All Tasks', and click 'Import'.

4
Complete the Wizard

Follow the Certificate Import Wizard to browse and select your downloaded AWS certificate file, then complete the import process.

5
Verify Server Name

In Power BI, ensure the database server name matches the AWS endpoint exactly, then attempt the PostgreSQL connection again.

Import AWS RDS Certificate to Trusted Store
Connection Tip: Restart Power BI Desktop after importing the certificate to ensure the new trusted root is recognized.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Exported Data: Launch WPS Spreadsheet and open any CSV or XLSX file exported from your database or Power BI.
  3. 3. Analyze and Report: Use pivot tables, charts, and formulas to analyze your data with full Excel compatibility.
Free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsFamiliar interface for quick and easy data analysisBuilt-in PDF tools for sharing reports securely
microsoft office alternative - wps office

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.