Forum Discussion
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 followin...
Hi Anonymous
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