How to Connect to PostgreSQL Database from Power BI

Aiven Community
1

Provided the correct host, correct database name, and the username and password. But I could not connect to the PostgreSQL database from Power BI

image

2

By the way, I’m using a Free Plan.

3

Hey @Ley_Franz_Yu ,

For host, can you try putting the port number at the end?

Example: pg-2f592b6b-testproject-siou-john-doe-test.i.aivencloud.com:23318

The port number is listed where you find the Connection Information

image

Hope that helps!

4

I tried adding the port. And here’s the outcome:
image

5

:face_with_monocle: this does make it a bit tricky without being able to see the full configuration.

Would you be able to provide more screenshots of the configuration?

Please make sure any passwords are blocked :slight_smile:

6

Hello everyone, I have the same problem, has anyone found a solution?

I used every parameters but i believe its a problem with the SSL’s remote certificate

7

Hi, have you added the CA certificate to the powerBI endpoint?

You can grab it out of the console

image
image1374×71 2.31 KB

8

Hi, How can i add the certificate to the powerBI endpoint using the native postgreSQL connection?