Getting pretty annoyed with 'Premium'....Error: PipelineException: Invalid cast from 'System.DateTim

[Dan80]

Second time I have tried premium and both times want to cancel it within a week as the error messages aren't helpful and google doesn't help.  Can someone out there help me before I cancel premium again??

I am trying to set up a machine learning model based on a dataflow.  The dataflow works great and refreshes without a hitch but as soon as I try to refresh the ML model (as part of training it) the refresh bombs out with the below message.

From what I can find online (Chris Webb - what a legend!), it seems to be something around privacy settings but for the life of me I cannot find how to change these, I have 'ticked' the box to allow combining of data.

Error: PipelineException: Invalid cast from 'System.DateTime' to 'System.TimeSpan'. . RootActivityId = 6d251ab9-90c7-42a8-8076-abd29af185a7.Param1 = PipelineException: Invalid cast from 'System.DateTime' to 'System.TimeSpan'. Request ID: 1f8d5d35-cd98-2725-5157-0acf742826cf.

HELP!!

[Dan80 · Accepted solution]

Looks like the issue was to do with the source data having the hour column in time format, if I converted the hour to a number then the issue appears to go away.  For now, problem solved, but still struggling to understand the error messaging.  Thanks

[v-xiaotang]

Hi @Dan80 

Based on my search, it seems you are converting DateTime to TimeSpan, but this is an invalid conversion. You need to get the difference between the two datetimes before it can be converted to timespan.
-
if this issue is urgent, I suggest that you can also open a support ticket with MSFT to seek technical support,
https://powerbi.microsoft.com/en-us/support/

I'm very concerned about this issue. Any question, please let me know. looking forward to receiving your reply.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.