Connecting PowerBi Web to PostgresSQL hosted on AWS Relational Database Service (RDS)

submited by

Style Pass

2021-05-26 08:00:03

The problem with connecting PowerBi Web to PostgreSQL hosted on AWS has arisen frequently over the past few years. The process itself is not very complex, and so I’ve put together a short piece on how to establish this connection.

Firstly, I highly recommended that your data gateway is hosted on a Virtual machine such as Elastic Compute Cloud instance (Amazon EC2) or on a Virtual machine (Microsoft). The reason for this is that the machine must run and have the access to the Internet whilst your data on RDS is being updated.

After downloading the file, you need to install Npgsql-3.2.7.msi file. During the installation make sure you select the “Entire Feature to be installed on local drive” option.