Skip to main content
Microsoft Idea

Power BI

Needs Votes

Heroku (AWS) PostgreSQL

Vote (57) Share
Power BI User's profile image

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

Using data from our Heroku hosted application

Comments (8)
Power BI User's profile image Profile Picture

shubham bagherwal on 19 Sep 2022 06:23:50

RE: Heroku (AWS) PostgreSQL

please! we really need this.

Power BI User's profile image Profile Picture

Vineet Bhardwaj on 21 Dec 2021 10:41:45

RE: Heroku (AWS) PostgreSQL

This is required

Power BI User's profile image Profile Picture

Srinivas Kotekal on 14 Jul 2020 22:48:47

RE: Heroku (AWS) PostgreSQL

Yes, we need this support please.

Power BI User's profile image Profile Picture

Scott Goley 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

Power BI User's profile image Profile Picture

William Gillett 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.

Power BI User's profile image Profile Picture

Germán Cotogno 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?

Power BI User's profile image Profile Picture

Power BI User 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.

Power BI User's profile image Profile Picture

Widget on 05 Jul 2020 22:22:26

RE: Heroku (AWS) PostgreSQL

Yes please!