Unable to Export Data with Current Layout

[ibbbu-1975]

Tried to export a matrix visual data to Excel using the "Current data layout" option but as you can see it is greyed out.  I have tried the following options with same results:

• Create entirely new report from scratch.
• Reduce Matrix to only 1 column group, as opposed to 3.
• Change visual from Matrix to table
• Change data source from Live Connected an SSAS tabular model to an import SQL server.

So I'm dumbfounded as to why after all the changes I still am unable to export the data in its current layout.

Using on-premise PBIRS September 2022 version.

[v-xiaoyan-msft]

Hi @ibbbu-1975 ,

Please check if your report has touch these known limitiations:

• For export from matrix visuals using Data with current layout, consider the following:

  • Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns

  • Matrices with only one row and/or values but no columns will be exported as table (no right border separator)

  • If the Show on rows toggle is set to 'On' in Power BI Desktop for a table or matrix visual, the visual format would not be preserved when data is exported to Excel

  • If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu."

Best Regards,
Community Support Team _ Caitlyn

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

[ibbbu-1975]

Thank you for replying.  Unfortunately none of those seem to apply.  I even tried to export with just a table visual and I'm still seeing the Export Data with current layout feature greyed out still.  Honestly if I can just get this feature to work or just know it's a bug or a limitation with on-prem so I'm not wasting anymore time troubleshooting this.

Thanks