This project has moved. For the latest updates, please go here.

Output function incorrectly store datetime into .CSV



I tried to store output of DAX-query to .csv file.
Unfortunately datestamp is incorrectly stored in file.
  • In output window I see data in such format: 4/9/2017 2:43:00 PM (it would be nice to have switcher 12/24h in settings)
  • If I export datetime in Excel table I see it in such format: 4/9/2017 14:43:00
  • If I export datetime in .csv I see it in such broken format: 2017-04-09 02:43:00.000 (I lost my datestamp)
Looking forward for fix. Thanks!

-- Paul


dgosbell wrote May 5 at 1:14 PM

So in terms of the formatting in the output grid, for a number of releases now we look at the formatting defined in your data model and apply that. But we can only match the formatting if the name of the column in the output matches the name in the data model. If you project the column using some function like SUMMARIZE or ADDCOLUMNS we can't link the two.

In relation to the csv export I found the issue and in the next release your data will output as 2017-04-09 14*:43:00.000 (so correctly representing the 24 hour time)

paul_levchuk wrote May 5 at 1:55 PM

Thanks for quick reply.

Sounds good. Looking forward for next release.