How to export our visual with all layouts, formatting, font and background colors and row hierarchy

[Sam0906]

I have a matrix report with hierarchy.

Is there any way to download the entire data with layout in excel with out expand everything?

Thanks in advance.

[Sam0906]

Thank you for your reply. When i am using data with current layout it's not dowloading with entire hierarchy.

[v-shex-msft]

Hi @Sam0906 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[v-shex-msft]

HI @Sam0906,

I'd like to suggest you try to use the 'data with current layout' option when you export data from matrix:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng