Import data AWS RDS PostgreSQL -- PowerBI

Question

Dear community,&nbsp;We need to create personalized views to our users using as a data source our database PostgreSQL hosted in AWS RDS (eu-west-2).&nbsp;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.&nbsp;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.&nbsp;This works locally but when we publish reports in PowerBI online a similar error appears, but in this case we cannot apply previous solution:&nbsp;&nbsp;&nbsp;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?&nbsp;&nbsp;Best regards and thanks in advance!Carlos

anonymous · Accepted Answer

HI&nbsp;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&nbsp;
BTW, you can laos take a look the following blog if it helps:
Connection of Power BI with RDS PostgreSQL on AWS from Scratch&nbsp;Regards,
Xiaoxin Sheng

Forum Discussion

Import data AWS RDS PostgreSQL --> PowerBI

1 Reply

Related content

Import data from PostgreSQL

Mirroring from on-premise PostgreSQL and MySQL sources

PowerBi Online Service - PostgreSQL - Encrypted Connection

Converting PostGreSQL Date time field at the import using SQL Statement

PostgreSQL + powerbi desktop connection error