Data connection details RRS feed

  • Question

  • Hi,

    I'm trying to make a data connection from Excel 2016 to PostgreSQL database. I've installed the most current npgsql data provider (3.1.3), but I'm getting error message regarding SSL connection. How can I force Query & Transform to utilize SSL. An overall question is, where and how to you define details regarding the connection string with Query & Transform. I've tried to find documentation, but no success yet. 

    I've also tried with ODBC driver, but there I'm getting authentication error. With ODBC administrator the test connection works Ok. Also from Excel the "good old MS Query" can see the tables. With SQuirreL I can access the data without any problems. But I need the data in Excel, preferrably in Power Pivot (and later on Power BI).

    Thursday, June 9, 2016 3:55 PM