ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.

Hi Anonymous, pankajbirle, Anonymous, cfields22,

Are you using Power BI Service or Power BI Report Server? I guess you are using Power BI Service. Right?

If so, I need to confirm some details:

1. Is the issue with dataset or dataflow?
2. Is the dataset/dataflow refreshing stuck or running for long duration than before?

If your issue is with dataflow, the same issue has been submitted internally(#ICM: 273691054). Please be patient to wait for fixing. If there is any news, I will update it here.

If your issue is with dataset, there is currently no issue internally that is exactly the same as your error message. But there is an issue about snowflake dataset refreshing stuck or running for long duration than before(#ICM: 272592736). And there is an workaround, please check if it also work in your scenario:

Two options

1. Run SHOW PARAMETERS LIKE 'ODBC_QUERY_RESULT_FORMAT'

1. See if this option says value is "ARROW"
2. If ARROW, run ALTER USER SET ODBC_QUERY_RESULT_FORMAT='JSON'

2. If that did not work, contact Snowflake support to set ODBC_TREAT_DECIMAL_AS_INT=false in the server properties.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi vidhiarora095 and ManuelaOsorio ,

There is an issue in Snowflake driver that when combined with some options causes it to throw exceptions and end up in an infinite loop.

Engineers are working on the fix, ETA is 12/31/2021. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.