Data with the Current Layout Option for Export to Excel greyed out

[MR66]

Hi,
I have an user who can't export data matrix into Excel with the option "Data with the cureent layout" because it is greyed out.

On the other hand with my user, it is enable.
I have already tried to change the acces role of the user in the space work but there is no effect.

Best regards,
MR66

[v-csrikanth]

Hi @MR66 

The “Data with current layout” option for Export to Excel is greyed out in Power BI Report Server when using certain visuals or configurations. This option is only available for visuals that support it, and may be unavailable in these cases:

• The visual uses features not supported for export (e.g., certain custom visuals, grouping, or drillthrough).

• The report has been configured with settings that disable this feature.

• The visual is a map, R visual, or some custom visuals.

• You are viewing a paginated report, not a Power BI (interactive) report.

• The report is being viewed in a browser or environment where the export capability is restricted due to browser security or Report Server configuration.

Recommended actions:

• Try exporting data from a standard Table or Matrix visual to check if the option is enabled there.

• Ensure the report is published as a Power BI (interactive) report, not as a paginated (RDL) report.

• Update to the latest version of Power BI Report Server, as export features are improved and expanded in each release.

• For custom visuals, use the standard visuals or check with the visual’s documentation to confirm if export is supported.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[MR66]

Hi lbendlin,

Here is the export setting option on the deskstop (in frech version) :

[lbendlin]

How did you set this option on the desktop?