Forum Discussion
How to export data to excel to proper format
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.
Hello TriveniN ,
to have in the same format you should export it from Power BiI service as in the following article
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 💡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 mp4If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
Hello TriveniN ,
to have in the same format you should export it from Power BiI service as in the following article
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 💡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 mp4If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly