cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stephenmelbourn
New Member

Can't connect (app.powerbi.com) to AWS RDS PostgreSQL instance due to certificate validation error

I'm using the web based Power BI to try to connect to an Amazon RDS instance of PostgreSQL.

I can add the dataset and report for the AWS RDS PostgresSQL into the web based Power BI via the following procedure:

  1. Install Windows Power BI app
  2. Following this Power BI community post add AWS public key into Windows' trusted CA store for Local Machine
  3. Add PostgresSQL dataset into Windows Power BI application and provide credentials
  4. Create report based on this dataset
  5. Publish report and dataset to web based Power BI

When I try to use this published dataset for reports, it complains of not having credentials. When I try to add these credentials I receive the following error.

Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'
Activity ID:    ----
Request ID: ----
Status code:    400
Time:   Wed Dec 01 2021 14:51:24 GMT+1100 (Australian Eastern Daylight Time)
Service version:    13.0.17186.43
Client version: 2111.3.08807-train
Cluster URI:    https://wabi-australia-southeast-redirect.analysis.windows.net/

I've faced and been able to overcome this error with the Windows Power BI client via the updating of the trusted root CA store.

The challenges I face in my situation are:

  • I'm not able to add a power BI gateway
  • I can't find a way to add to trusted certificate authorities in the web based Power BI client. (Is this even possible?)

Are there any other ways I can overcome this issue so I'm able to add a dataset in the web based Power BI client that targets my AWS RDS PostgreSQL instance so I can create reports that are updated automatically?

2 REPLIES 2
Ailsa-msft
Community Support
Community Support

Hi @stephenmelbourn 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regard

Community Support Team _ Ailsa Tao

Ailsa-msft
Community Support
Community Support

Hi @stephenmelbourn 

I think you can try to use the Postgres connector to get data from the data source which you deploy on AWS.
Then you need to use a gateway to manage data source refresh(turn on the option to use gateway handle cloud data source) and install the 'remote access credentials' to the device that you installed the gateway and handle these operations.(it used to verify the AWS credentials)

Merge or append on-premises and cloud data sources 

BTW, you can take refer to the following blog if it helps:

Connection of Power BI with RDS PostgreSQL on AWS from Scratch 

 

Best Regards

Community Support Team _ Ailsa Tao

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors