Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |