Help! with a time column

[dmarics28]

Hi Guys,

Help needed.

I have a column from an excel data source. it is in this format   0:30:00  (0 hours, 30 mins, 0 secs)

When it loads up in the power query, the format is automatically changed to 12:30:00 AM - Its auto converting to an actual time.

How do i change or get my actual excel data in, rather than this auto correction?

[lbendlin]

in Power Query remove the "Changed Type" step and specify the column types manually (for example "duration").  In the new July version of Power BI desktop you can now finally switch off that auto format silliness globally.

[dmarics28 · Accepted solution]

Oh Thanks so much. That did it.

It was auto changing when Promoting headers (Use First Row as Headers) for some reason. Thanks!