Export to excel is not working properly when using a Matrix visual with the show on rows option selected under the values area in the format pane.
Here is what the report looks like in desktop...
Data and report look the exact same on the Power BI service. But when I click the elipsis on the visual within the service and click on "export data" and choose "data with the current layout" and then "export" I get the following (If I choose summarized data it doesn't work either)...
I know that formatting changes aren't applied to the exported data but even though this option is in the formatting pane it is really more of a structural changes to the display of the data and should be kept through the export process. Otherwise, the description of the "data with current layout" text is incorrect because it is not in the same layout.
-
v-xiaoyan-msft
on:
Possible Bug with Rounding
-
v-xiaoyan-msft
on:
export to excel
-
v-xiaoyan-msft
on:
Is there any way to see the full name of the colum...
-
v-xiaoyan-msft
on:
Issue with Client Credentials Grant Type for Power...
- MattSwan on: Multi-Select Possible in Filter Panel even when Re...
-
v-xiaoyan-msft
on:
TypeConversionFailure when not trying to convert
-
Idrissshatila
on:
Power Query Filter Rows Basic UI bug
-
v-yetao1-msft
on:
Wrong french translation for "reader" permission
-
v-yetao1-msft
on:
'Select All' option in a slicer is not intuitive w...
- MurtoMan on: Bug in quick filter in PBI Desktop
Update:
Currently it has been confirmed as a known issue internal, engineers are working to fix it. If there is any ETA about it, would update here continously.
Best Regards,
Community Support Team _ Yingjie Li