topic Re: Data with the Current Layout Option for Export to Excel greyed out in Report Server

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

MR66 — Tue, 11 Mar 2025 10:36:44 GMT

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

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

lbendlin — Tue, 11 Mar 2025 19:31:14 GMT

How did you set this option on the desktop?

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

MR66 — Thu, 13 Mar 2025 09:27:39 GMT

Hi lbendlin,

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

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

v-csrikanth — Mon, 26 May 2025 07:15:09 GMT

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.