Status:
New
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. .. RootActivit...
So, I wonder if this might be useful - we have just switched to a Premium workspace and a Dataflow that has been happily chugging along for months just filpped out on us.
No explicit conversion to date type, in fact deliberatly kept as datetime to allow incremental refresh. However, there is a Table.Group line in the query and it looks like the conversion has added a type nullable datetime to the group command (we need the latest date as part of the grouping). Changing this got the query up & running straightaway 😊