cancel
Showing results for 
Search instead for 
Did you mean: 

Dataflow Refresh Problem - We cannot convert the value #datetime() to type Date- URGENT!

Since Monday our dataflows stopped updating

 

The error that is given is the following: “Error: Expression.Error: We cannot convert the value #datetime(2019 9 26 0 0 0) to type Date. .. RootActivityId = da928912-31f6-40a6-994c-761c55104956.Param1 = Expression.Error: We cannot convert the value #datetime(2019 9 26 0 0 0) to type Date. Request ID: a033c9df-0c02-7ccf-df39-c48a1c29335c.

 

 And it happens in all 3 workspaces (dev-test=prod and with different tables and different dates!)

 

We also notice that the datetime function in the error message is missing commas. We haven't made any changes in the code and are not explicitly doing any datetime to date conversion... 

 

This is a critical problem for us because the whole organization is now dealing with 2 days old data. Please advice!

Status: New
Comments
olgaia
Frequent Visitor

For us the workaround was casting all our dates as datetimes. Things worked afterwards.

v-chuncz-msft
Community Support

@olgaia 

 

A similar issue has been reported internally, so stay tuned.

CRI 245776965

v-chuncz-msft
Community Support

@olgaia 

 

The fix is deployed. You may check it again.