Forum Discussion
Dataflow and Dates/Times
Anonymous I mean that when I try to create a dataflow for my CSV data set it says that it has an unsupported format. The error occurs no matter what transformations I try to make to the dataset. My main concern is that any numerical/date/time columns are being recognized as text. When I "transform" the data to format it as a date/time/number PowerBi gives me the folding error and says the format is unsupported. When I leave the data set as text, it will save the dataflow, but I cannot use the data without the number/time/date formatting.
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.
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?
Anonymous otravers
My exact issue is that the dataflow does not save if I have done ANY TRANSFORMATIONS TO THE DATA