sgoley / DirectQuery-for-ODBC-in-PowerBI

Direct Query for PostgreSQL via ODBC with SSL
MIT License
14 stars 9 forks source link

error when accessing timestamp without time zone #12

Open mstrzelc opened 2 years ago

mstrzelc commented 2 years ago

We are getting an error when accessing timestamp without time zone columns.

Some details:

September 2021
Product Version:
2.97.801.0 (21.09) (x64)
Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..
OS Version:
Microsoft Windows NT 10.0.19042.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528372]

It works nicely with other data types, including timestamp with time zone. My guess would be there is a no defined conversion for timestamp without time zone type, while there is one for timestamp with time zone.