DataConnectors icon indicating copy to clipboard operation
DataConnectors copied to clipboard

cannot folder expression - data connector & PostgreSQL ODBC

Open xsgao-github opened this issue 5 years ago • 1 comments

I want connect to Postgres ODBC data source with direct query enabled. So I took this sample project, https://github.com/Microsoft/DataConnectors/tree/master/samples/ODBC/SqlODBC, point Config_DriverName variable to "PostgreSQL Unicode(x64)" (name of my psqlODBC driver, version 03.51), and set ConnectionString based on a working ODBC DSN.

I am using Power BI Desktop, Version 2.61.5192.601 64-bit (August 2018), and there is no problem to add one table to my Power BI report. But whenever I put a column into a table (or any other viz), I got this error:

OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.

And it happened to any column, varchar, number or date.

Attached is PBI report and log files under Power BI Desktop\Traces directory.

Any help is appreciated.

Traces.zip

postgres odbc-data connector.zip

P.S. By "a working ODBC DSN" I meant I can connect to this ODBS DSN, import tables and render viz, within Power BI Desktop. But of course without direct query mode.

xsgao-github avatar Aug 20 '18 19:08 xsgao-github