Hi All,
Our organization has been running several dataflows against snowflake, and recently they have been throwing this error about 40% of the time when refreshed on PBI Service.
ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.
Given the randomness of this error (a dataflow will often fail, then suceed immediatly after) we do not think the issue is actually a date/timestamp value error.
There was another thread posted a few months ago about this exact same issue:
ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.
In this thread, a workaround was given for dataSETS, but the issue with dataflows was noted as being a known issue in the snowflake driver with a fix expected on the way. It seems this fix was introduced, as we also had errors around the time the original thread was posted and those errors eventually disappeared. They have returned, however, and more frequently than before.
Has anyone had any experience with this issue, and are there any solutions for resolving it for dataflows?
