Import data AWS RDS PostgreSQL --> PowerBI

[cferraz_hemav]

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

[v-shex-msft · Accepted solution]

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