Information error when exporting array to excel

[Syndicate_Admin]

Hello good afternoon, when exporting a BI matrix to csv and then to excel, the data that is initially displayed varies which causes them to be considered erroneous ratios. What could be causing this issue?

[Anonymous]

Hi @Syndicate_Admin ,

It is not supported for Power BI Desktop to export data with formatting.

You could submit this as an idea.

https://ideas.powerbi.com/ideas/ 

Or you could publish the report to Power BI Service use the Data with current layout option.

If I misunderstood your meaning, please share more details, screenshots would be the best.

Best Regards,

Jay

[AllisonKennedy]

Not sure from the little info you've provided - are you exporting from Power BI service? What is the original display and what is the new output? Have you tried the new export with current layout feature? That may be what you want for matrix visual, but can only export to Excel (not CSV) with that option. https://powerbi.microsoft.com/en-us/blog/export-to-excel-improvements-for-table-and-matrix-visuals-p...