web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

New

Export to CSV Time format

Vote (13) Share
Roy de Groot's profile image

Roy de Groot on 18 Aug 2016 22:11:56

If I export a column with the time format to CSV, the time becomes a datetime field. A workaround is to rename the column and create a new calculated column with an explicit format function, but this creates extra unnecessary data and columns. Workaround source: http://community.powerbi.com/t5/Desktop/Excel-time-format-h-mm-ss-on-power-BI/m-p/48372#M19141