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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors