refresh error
2 TopicsODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.
Hi All, I'm wondering if someone can help me with this issue. I have set daily refresh on my report and it's been working fine for the past 5-6months, until this week I recieved scheduled refresh failure notice with the error message : ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value. I have four tables in this report and all are coming from snowflake which all are using the same date source. For trouble shooting I created four reports each contain on of the four tables and refresh the data. Only one table is giving me trouble, but how is this possible if all tables are using the same dates? I have also tried refreshing the report with powerbi desktop and it gives me no issues. Does that mean the issue is not within the dataset but from powerbi server? Sometimes if I refresh the report multiple times it will succeed but most of the time it's giving me the same error message. Is there a way of ignoring the ODBC error since I'm confident that all my date values are valid?Solved20KViews6likes18CommentsContainer exited unexpectedly - What does this error means?
Hi, I have a dataset scheduled to refresh at 6 pm yesterday. But when I checked the status today, I saw this error message, which I have never seen it before. And at the same time, I got an email said the Data Refresh has been disabled. Data source error: We're sorry, an error occurred during evaluation.;Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028.. The exception was raised by the IDbCommand interface. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: e5f7ee55-cbf0-4fec-91f8-3d54f33bdf4f Request ID: 124e1e7a-be38-4e38-961d-843b07bf3b86 Time: 2020-09-08 01:15:36Z The dataset I'm working on is pretty large (around 10G). And the refresh is scheduled in a premium workspace. In the past, it got throttled several times during a scheduled refresh because of the memory issue on capacity. But I never got this message before. I checked the gateway setting; it's all good. Please help me take a look at the error message, and I really appreciate all help!! Thank you, Kelly8.9KViews0likes2Comments