Forum Discussion

ibbbu-1975's avatar
ibbbu-1975
Frequent Visitor
3 years ago

Unable to Export Data with Current Layout

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 n...
Excel
Report Server
Report Server + Sep 2022
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    ibbbu-1975
    Frequent Visitor
    3 years ago

    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