Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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/...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

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

  • Anonymous's avatar
    Anonymous
    7 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

LivioLanzo they are inserted by hand. No subtraction. They look like the picture below, which is a part of the excel sheet:

 

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    LivioLanzo

     

    thank you for your help. It worked :smileyvery-happy:

    I converted the source column to general, imported it in the PBI model and then set the data type as Duration. 

     

     

    The only problem remained, is that it is corrected the PowerQuery mode yet in the PBI desktop data section, it is not showed correctly :smileyfrustrated: