HOW TO CONNECT POSTGRES SQL TO POWER BI USING LOCAL POSTGRES AND AIVEN

Connect to Local PostgreSQL from Power BI

1. Open Power BI Desktop
2. Click Get Data
3. Choose PostgreSQL database
4. Enter: Server: localhost:port Database: postgres

Enter your PostgreSQL username and password

Click Connect

Once connected, you can load or transform your data.

Connecting Power BI to PostgreSQL Hosted on Aiven

Aiven

Step 1 — Create a PostgreSQL Service in Aiven

In the Aiven console:

1. Click Create Service
2. Select PostgreSQL
3. Choose cloud vendor, region, and plan
4. Deploy the service

Aiven provides:

Host
Port
Database name
Username
Password

Host: pg-12345.aivencloud.com
Port: 26257
User: avnadmin
Database: defaultdb

Test Aiven Connection via Terminal

Step 5 — Connect Power BI to Aiven PostgreSQL

1. Open Power BI Desktop
2. Select Get Data → PostgreSQL database
3. Enter:

Server: pg-12345.aivencloud.com
Database: defaultdb

Enter Aiven username & password
Click Connect

Power BI will establish a secure SSL connection to Aiven.