How to export data to excel to proper format

[TriveniN]

Below report is matrics report and when I export to excel using option 'Data with Current Layout' getting data in another view (Please see second screenshot).

How to get data when I export this matrix view to excel with same exact format (report)? 

Regards,

Triveni N.

[Idrissshatila · Accepted solution]

Hello @TriveniN ,

to have in the same format you should export it from Power BiI service as in the following article

https://powerbi.microsoft.com/en-cy/blog/export-to-excel-improvements-for-table-and-matrix-visuals-p...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Ritaf1983 · Accepted solution]

Hi @TriveniN 
To export the matrix to Excel in the same layout as in the pbi report you should select the option "Data with current layout" when you export it.
Unfortunately, I am out of the limit of screenshots that I can add to the discussions so I recorded my screens to show how it works you can download it from the  attached link:
The link to mp4 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila · Accepted solution]

Hello @TriveniN ,

to have in the same format you should export it from Power BiI service as in the following article

https://powerbi.microsoft.com/en-cy/blog/export-to-excel-improvements-for-table-and-matrix-visuals-p...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡