Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TriveniN
Helper II
Helper II

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)? 

TriveniN_0-1695224260817.png

TriveniN_1-1695224329813.png

 

Regards,

Triveni N.

 

2 ACCEPTED SOLUTIONS
Idrissshatila
Super User
Super User

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

Ritaf1983
Super User
Super User

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

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

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
Super User
Super User

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors