Solved: Duration wrongly converted to Date-Time type - Page 2

Anonymous · ‎01-29-2019

I am getting data from an excel file which include a column which shows duration as mm:ss:ms

But when I import the data to Power BI Desktop with Power Quey, it converts this column to date/time format, like the picture below:

I don't know how can I solve this issue.

Any idea?

LivioLanzo · ‎01-29-2019

you can convert them within excel to general format and then copy paste them into Power BI

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

View solution in original post

Anonymous · ‎01-30-2019

PowerBI does not currently support milliseconds in date time datatype. I solved the problems like follow:

convert the excel doc to general, load it into PowerBI, and multiply the value by 86400 to get the total number of seconds.

Duration wrongly converted to Date-Time type