Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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"

 

However when i try exporting i get this:

 

Can somebody help me out?

 

Thanks in advance!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    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.

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your reply.

      I've already checked this setting:

       

      • Burningsuit's avatar
        Burningsuit
        Icon for Resident Rockstar rankResident Rockstar
        4 years ago

        HI Anonymous 

        What are the PBIX settings, in Power BI desktop ? I've a feeling these may beat the Service settings.

        in Power BI desktop go to File/Options & settings/Options/Current File/Report Settings.

        Hope this helps

        Stuart

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    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.