Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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 💡
Proud to be a Super User! | |