Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duration converted to a Date Time Format

I have downloaded data from Garmin. The Elapsed time field is a General datatype and looks like this:     It lands in Power BI and ends up like this:       I've searched through th...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I think I figured it out. I have the field in Excel set to General

    I import the data

    leave it as a Date/Time

    I don't transform anything but go to the Data tab in the builder and change the format to be hh:nn:ss

     

     

    Ignore the 2nd 2 columns I was testing.

     

    It would be nice though if PBI did not convert these types of data. Leave it as is. I can't figure out if that's an option or not...

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I think I figured it out. I have the field in Excel set to General

I import the data

leave it as a Date/Time

I don't transform anything but go to the Data tab in the builder and change the format to be hh:nn:ss

 

 

Ignore the 2nd 2 columns I was testing.

 

It would be nice though if PBI did not convert these types of data. Leave it as is. I can't figure out if that's an option or not...