Dataflow and Dates/Times

[Marquian]

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? 

[Marquian]

@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: DataflowObjectModelTypeNotSupportedException

[otravers]

Can 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?

[Marquian]

This is the message I get when I try to save the dataflow. 

[otravers]

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).

[Marquian]

@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. 

[otravers]

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.

[Marquian]

My exact issue is that the dataflow does not save if I have done ANY TRANSFORMATIONS TO THE DATA

[Marquian]

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?

[Marquian]

@Anonymous @otravers 

[Anonymous]

Hi @Marquian 

You mean the influential columns are not regular columns ?

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Marquian]

It seems to be affected by any transformations or column additions