Forum Discussion
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 information in relation to date and time. Is there something I can do to fix the error?
11 Replies
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.
Aah, OK, thanks for clarifying.
"Casting" a data type means changing and applying it, like converting a column that comes as text into a date data type.
Do you have by any chance a column set to Duration? I think that's not supported in Power Query Online (i.e. dataflows), only in a dataset (i.e. by changing to that type in Power BI Desktop).
Anonymous otravers I can't determine what is not supported, so I can remove it from the data Activity ID: 63cdee82-bbc3-3090-7b9d-6f8f2d9f6d55
Request ID: 74d7d10f-d038-38e5-75e2-df1143374bbe
Status code: 400
Error Code: DataflowObjectModelTypeNotSupportedExceptionCan you post the entirety of the M code for your data type transformation step so that we can see all the data types for all columns?
