Power BI

New

Heroku (AWS) PostgreSQL

Vote (49)

Power BI User on 23 May 2015 00:26:15

Using data from our Heroku hosted application

Comments (6)

Comments (6)

d190e1ce 23c6-ea11-a812-000d3a4e3654 on 14 Jul 2020 22:48:47

RE: Heroku (AWS) PostgreSQL

Yes, we need this support please.

c181bfdc 8aa7-4c1f-adf6-37f199ac50af on 06 Jul 2020 00:07:03

RE: Heroku (AWS) PostgreSQL

Hi all,

This is possible for free for both Import and DirectQuery methods via an ODBC custom connector I've been developing. As far as I'm aware - that's the only way to get around Heroku's inability to add your own certificates.
Blog post here:
https://medium.com/just-readr-the-instructions/heroku-postgres-and-powerbi-ab6b0a18c40f

Project homepage here:
https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI

Scott

ee7eb18e 60ae-4b7f-94bc-0ea912c8d62e on 05 Jul 2020 22:58:27

RE: Heroku (AWS) PostgreSQL

Yes - connecting to postgresql on heroku. First application I was trying to implement with powerbi.

f3b88f00 cbc7-4eaa-9d21-8aa238bd323a on 05 Jul 2020 22:52:14

RE: Heroku (AWS) PostgreSQL

Has anyone tried to connect to PostgreSQL database at heroku recently? I have successfully connected to the database on the on-premise Powerbi, but if I upload the report it doesnt work. Got any ideas?

452c7c0e 348d-4874-86cf-9c4a76516ec4 on 05 Jul 2020 22:25:01

RE: Heroku (AWS) PostgreSQL

100% agree. We had to buy a subscription to BIME.io MS PowerBI definitely needs to support Heroku Postgres.

34100635 1b01-4b80-9384-9ed769a654fc on 05 Jul 2020 22:22:26

RE: Heroku (AWS) PostgreSQL

Yes please!