Forum Discussion

Dan80's avatar
Dan80
Icon for Helper II rankHelper II
5 years ago
Solved

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

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 ag...
Need Help
  • Dan80's avatar
    Dan80
    5 years ago

    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's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

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.