Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Duration import from Excel incorrect

I set my column in Excel to hh:mm:ss, but when it imported into Power BI it is 12/31/1899 12:00:00AM. What's the magic step to get my minutes and seconds back in my Power BI query editor? I'm a new ...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

Probably after your #"Changed Type" line. 

Don't forget to not paste the first two lines as stated.

 

Also, you will need to change the Table reference in my #"Convert to Number" step to the appropriate one in your code (probably to #"Changed Step"; and you should probably eliminate the type definition for the Funnel Duration column in your #"Changed Step" code

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sorry this isn't quite working. The #"Convert to Number" and #"Changed Step" are both giving me errors.

 

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago


    I would expect errors because you

     1. Did not paste the code in the proper location (afterr your #"Changed Step" line (step))

     2. and also you didn't change the table reference in my #"Convert to Number" step.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      My apologizes. I'm new to Power BI and I didn't understand your instructions completely.