Forum Discussion
Duration wrongly converted to Date-Time type
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/...
you can convert them within excel to general format and then copy paste them into Power BI
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.
HI Anonymous
try to convert it to decimal type
As I explained to BjoernSchaefer, before doing anything power query convert this column to the date/time format, and this rounds up the numbers, therefore turning it to a decimal type will not solve the problem