Power BI connection with AWS RDS PostgresSQL or DBeaver

[duardo08]

Hi,

I'm trying to connect PBI Desktop with an AWS RDS database, but I'm not getting it, I get a credential error. My company's infrastructure team does not allow me to install the PostgreSQL ODBC driver on my machine to make the connection, and also said that the database does not have the ability to access via ODBC. I can connect to this database through DBeaver, but I cannot collect data from it. I've also tried disabling credential checking, but it still didn't work.

Is there any way I can connect to this AWS RDS Postgres directly without installing other programs/drivers or through DBeaver?

Thanks for the attention!

[Anonymous · Accepted solution]

Hi @duardo08,

You can take a look at the following link about using power bi to get data from PostgreSQL that host on AWS RDS: (required Npgsql driver and import certificate to device)

Solved: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Power BI Community

In addition, you can also try to use other service to connect to AWS RDS and map other types of data drivers, then you can use this type of connector to indirectly get data from the the AWS RDS.

Regards,

Xiaoxin Sheng