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.