Skip to main content

Power BI

New

CSV export to match visual

Vote (30) Share
Jamie Llewellyn's profile image

Jamie Llewellyn on 08 Mar 2016 03:03:50

Now that users are getting exports from our visuals, they are noting that the export does not match the source visual.

Example: I have a matrix with row header of 'Products' but products is the second column in a .csv export.

Comments (1)
Jamie Llewellyn's profile image Profile Picture

30c864a2 a7c0-4315-8c4b-787e67693612 on 05 Jul 2020 22:33:49

RE: CSV export to match visual

I noticed that time values are different when exported. In the presentation, a table data value would be 1:05:57 PM, but when exported to excel has the value 1899-12-30 13:05:57. I've checked the original value which is time and seems to be exporting it as date time. Opening the file in excel and changing the format also does nothing.