Forum Discussion

WBackOffice's avatar
WBackOffice
Frequent Visitor
4 years ago

Connect AWS RDS postgresql base to power bi

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...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.