Forum Discussion
Solved
Help! with a time column
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 ...
Oh Thanks so much. That did it.
It was auto changing when Promoting headers (Use First Row as Headers) for some reason. Thanks!
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.
Oh Thanks so much. That did it.
It was auto changing when Promoting headers (Use First Row as Headers) for some reason. Thanks!