Forum Discussion

cferraz_hemav's avatar
cferraz_hemav
Icon for Helper I rankHelper I
5 years ago
Solved

Import data AWS RDS PostgreSQL --> PowerBI

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 D...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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