Forum Discussion
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 ...
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.
My apologizes. I'm new to Power BI and I didn't understand your instructions completely.