Date format changes when when report is exported from Bower BI Server to Excel.

[Axeman72]

I am experiencing issues with the Date formats of one of my columns changing when when a report is exported from Power BI Server to Excel. I am unable to select the “Data with current layout” option to preserve the visual structure and formatting. If anyone has any insight on this issue or trouble shooting suggestions please respond. Thanks in advance for your response.

[Anonymous · Accepted solution]

Hi @Axeman72 ,

When you export visual data in Power BI Service, the Data with current layout option is only avaliable for table and matrix visuals, please visualize data with this type visuals, then export the data.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.