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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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