Forum Discussion

RdH_Stipter's avatar
RdH_Stipter
New Member
4 years ago
Solved

Export data with current layout is unavailable

Hi all,   I can't use the function export data with current layout in my reports. I've checked the report settings and have made sure they're set on: "Summarized data and data with current layout" ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi RdH_Stipter ,

    What is your visual? Now it only allows the export of data from a table or matrix visual to Excel while preserving the formatting of the visual, including number formatting and grouped (merged or unmerged) dimensions.

     

    More details: Export to Excel Improvements for Table and Matrix Visuals (Preview) 

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi RdH_Stipter ,

What is your visual? Now it only allows the export of data from a table or matrix visual to Excel while preserving the formatting of the visual, including number formatting and grouped (merged or unmerged) dimensions.

 

More details: Export to Excel Improvements for Table and Matrix Visuals (Preview) 

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yhoefm's avatar
yhoefm
Regular Visitor
3 years ago

Hello, 

First of all, you can only test this issue in Power BI Service as this export feature is not available in PBI Desktop (29 Oct 2022).

Make sure in your visual (=table or matrix) properties you enabled header icons (=On!). 

 

It's very subtle and I've only noticed after a end-user send me this issue. 

-> When the header icon is off, the visual will also give you a header icon menu with possibility to export data.

HOWEVER it's a different one, you need the real header icon menu to have this feature enabled.