Import data AWS RDS PostgreSQL --> PowerBI

cferraz_hemav — Tue, 12 Jan 2021 09:59:04 GMT

Dear community,

We need to create personalized views to our users using as a data source our database PostgreSQL hosted in AWS RDS (eu-west-2).

Following documentation, we are trying to use DirectQuery to avoid the need to refresh periodically our datasets. The idea is to attack a specific views in our database specifically designed for this reports.

Creating the reports in PowerBI Desktop we found an error with remote certificates (AWS RDS!!), but we were able to 'solve' the problem following this solution. This works locally but when we publish reports in PowerBI online a similar error appears, but in this case we cannot apply previous solution:

How can we solve this? In case this doesn't have a solution for AWS RDS-PBI compatibility, which strategy shall we follow to publish online reports with updated data from our AWS RDS database?

Best regards and thanks in advance!

Carlos

Re: Import data AWS RDS PostgreSQL --> PowerBI

Anonymous — Thu, 14 Jan 2021 01:57:15 GMT

HI @cferraz_hemav,

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 laos take a look the following blog if it helps:

Connection of Power BI with RDS PostgreSQL on AWS from Scratch
Regards,

Xiaoxin Sheng

topic Import data AWS RDS PostgreSQL --> PowerBI in Developer

Import data AWS RDS PostgreSQL --> PowerBI

Re: Import data AWS RDS PostgreSQL --> PowerBI