Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time error

I've two different columns for time and date. PowerBI detects the date format, but when I try to change time type to (Time, Date/time) it throws an error. Error:  DataFormat.Error: We couldn't pars...
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

As tested, once imported, it shows as text type for column "ACCIDENT_TIME",

then i replace the "." with ":" for this column, then it can be changed into time type without problem.

If you convert it to datetime, it would show as 12/30/1899 3:00:00 AM.

To get datetime column, please merge [ACCIDENT_DATE] and [ACCIDENT_TIME] with "space", then change it into datetime type.

 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, Maggie, it worked out.