DataConnectors
DataConnectors copied to clipboard
cannot folder expression - data connector & PostgreSQL ODBC
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.
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.