Export data with current layout is unavailable

[RdH_Stipter]

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!

[v-rongtiep-msft · Accepted solution]

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]

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. 

 

[jennratten]

Did you check the settings in the Power BI service and in the pbix?

https://community.powerbi.com/t5/Service/Visual-s-quot-Export-data-quot-greyed-out/m-p/772264 

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-de... 

[RdH_Stipter]

Thanks for your reply.

I've already checked this setting:

[Burningsuit]

HI @RdH_Stipter 

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