Forum Discussion

eperrone's avatar
eperrone
Frequent Visitor
5 years ago
Solved

Connecting to Postgres - New and Confused

Hi folks,

 

New to PowerBI and trying to figure out how to connect to a PostgreSQL databae hosted on AWS RDS.  I was able to get an odbc driver installed and it seems to connect but when I go to hit a table the connection never  gets past showing data preview.  I poked around some and found some posts about installing npgsql but frankly I got lost when trying to follow those instructions.

 

I came across some instructions to install an msi package for npgsql but I could not find a msi package only source code and a reference to nuget packages.  I am not sure what that is or how to work with it.  Could anyone give me some assitance?

 

Thanks so much!  New to PowerBI

Need Help
  • eperrone's avatar
    eperrone
    5 years ago

    Hey folks,

     

    IO found out that my PowerBI was very old and updated to the laest version.  The Postgres native connection worked right out of the box (I had to clear the encrypt connections to now use SSL) but other that it works great.

     

    Thanks for all the help.

    Eric

     

     

6 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    eperrone 

     

    There is already a connector for Amazon redshift.

    File --> Home --> Get Data --> More --> Database --> Amazon Redshift

     

    Try using this native connentor

     

    • eperrone's avatar
      eperrone
      Frequent Visitor
      5 years ago

      I am getting an SSL error certificate verify failed. 

      • eperrone's avatar
        eperrone
        Frequent Visitor
        5 years ago

        Ok so is Amazon RDS the same as amazon Redshift?  I think they are different?

  • eperrone's avatar
    eperrone
    Frequent Visitor
    5 years ago

    Update on this so I went back to the ODBC connector and just waited it out and eventually the data set did populate and return data.  It seemed to be hung up when it appears it was just takeing a very long time to populate.  (>30 min).  I'll have to see if I can speed that up somehow.

     

    Thanks

  • eperrone's avatar
    eperrone
    Frequent Visitor
    5 years ago

    Hey folks,

     

    IO found out that my PowerBI was very old and updated to the laest version.  The Postgres native connection worked right out of the box (I had to clear the encrypt connections to now use SSL) but other that it works great.

     

    Thanks for all the help.

    Eric