Connecting PowerPivot to PostgreSQL database RRS feed

  • General discussion

  • When I try to connect PowerPivot PostgreSQL database(at the point when I need to "Choose how to import the data". When I choose to select from tables and views, I get error below. When I choose to write sql query and press on 'design' button, empty window opens up (it should open tables from database)), I get this error message:

    "No tables were found in the data source. Check the connection information and login credentials."

    I use "Connection to data source - Others (OLEDB/ODBC)". I have installed PostgreSQL ODBC driver. I use PostgreSQL ANSI driver (tried UNICODE, got the same error). When I test connection, it says "connection succeeded). Also If I use same connection to same database for Pivot Table, everything works and I can take any table from my database.

    I use MS Office 2012 32 bit and PowerPivot is 32 bit too.

    So I suppose no one got any ideas what could be wrong?
    Wednesday, January 16, 2013 7:09 AM

All replies

  • Hi, I am having the same problem. Have you found a solution for this?


    Friday, February 1, 2013 11:22 AM
  • Have you found a solution for this? If you haven't I have mine working. I'm looking right now for a way to connect my power BI to a postgreSQL database. If you are familiar with that please let me know. Thanks.
    Wednesday, October 23, 2013 6:21 PM