Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to Connect Power BI to Heroku PostgresSQL?

Hi, 

I am struggling to follow the instructions here:

https://stackoverflow.com/questions/60102636/power-bi-postgresql-data-import-error-the-remote-certificate-is-invalid-accord 

What I am doing:


First here are my credentials

 

Host: ec2x
Database: d4x
User: box
Port: 5432
Password: 08x
Heroku username: user
Heroku password: password​

 

 
1. Download PostgreSQL ODBC driver and install => I have succesfully installed the driver.

2. I follow step 2 succesfully here: 

 

 3. For the next step, I put the user name as my data base user, and the password as my database password. Using the credentials listed above.

For the connection string: 

 

 

PORT=HEROKU_PORT;DATABASE=HEROKU_DATABASE;POOLING=True;MINPOOLSIZE=1;MAXPOOLSIZE=20;HOST=HEROKU_HOST;COMPATIBLE=2.2.3.0;USER ID=HEROKU_USER;PASSWORD=HEROKU_PASSWORD;SSLMODE=require

 

I replace the following: HEROKU_PORT, HEROKU_DATABASE, HEROKU_HOST, USER ID, PASSWORD.

My string therefore becomes (using my example credentials:

 

PORT=5432;DATABASE=d4x;POOLING=True;MINPOOLSIZE=1;MAXPOOLSIZE=20;HOST=ec2x;COMPATIBLE=2.2.3.0;USER ID=user;PASSWORD=password;SSLMODE=require

 

So the box filled in is:

 

 

But I keep getting this issue:


Can someone please help me out here? I seem to following the instructions step by step and keep hitting this issue.

Thanks!





5 Replies