Forum Discussion
Changing column types in advanced editor
Hello, The query worked well before the Pervasive DB was updated. And now I get this error: DataSource.Error: ODBC: ERROR [22007] [Pervasive][ODBC Client Interface]Invalid date, time or timestam...
Thank you for the replies so far!
I still haven't figured out how to solve this issue. There is no SQL statements in the ODBC connector.
Is it not possible to get the raw data to Power Query and filter the errors/dates causing the errors there?
I kind of solved this.
I used the SQL expression in ODBC connector to select the columns I needed from the database.
Then I wanted to try to select all of the date/time columns from this table one by one to see which column was causing the initial error. Not a single error with any of the existing date/time columns. So this is kinda weird, there may be something shady with the current version of the database and Power BI or ODBC drivers?