Connect AWS RDS postgresql base to power bi

[WBackOffice]

Hello Community,

I am trying to configure the update schedule of the datasets of the reports that have been uploaded to the workspace. However, when I try to configure a DataSource, which in PowerBI Desktop works fine, I get the following error.

The database that I am trying to configure as a Data Source is: Cloud: AWS
Product: RDS
DB engine version 11.12
DB Instance class: Burstable classes "db.t2.xlarge"
Certificate authority: rds-ca-2019
Engine: PostgreSQL The database is public today, it is accessible from the internet without the need for VPN, only pointing to the host, and port 5432.
Authentication is by username and password.

The type of license I have is PRO.

Is there any way to correct it?

Thanks and regards

[v-zhangti]

Hi, @WBackOffice 

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 _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. I had some issues for that connection too some years ago. You need to configure a certificate in the VM hosting a gateway. I know that postgres can get rid of gateway nowadays, but I'm not sure you can get rid of it if it is hosted in AWS.

This is what I have done years ago. I had created an EC2 with a Standard Gateway and configure it:

https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws

Then I was able to connect Power Bi Service to RDS Postgres.

I hope that helps,