1
Vote

Output function incorrectly store datetime into .CSV

description

Hi.

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

comments

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.