Forum Discussion
Anonymous
3 years agoNot applicable
Dataflow and Dates/Times
Hello, I am trying to create a data flow using my dataset. However, I received the following error related to any date and time field. It will only allow them to be uploaded as text. I need to track ...
otravers
3 years agoCommunity Champion
The lack of query folding is not an error, it's just a warning that the query won't refresh as efficiently because the entire chain of transformation can't be pushed back to the source (typically a SQL database):
https://learn.microsoft.com/en-us/power-query/power-query-folding
Just save your dataflow with the data type cast to date/time.
Anonymous
3 years agoNot applicable
It will not let me save if the error is present. I am not sure what you mean by cast the dates. Can you give more clarity?
- Anonymous3 years agoNot applicable
Anonymous otravers