Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

dsmithchildren

Excel export not working. Matrix visual with "show on rows" in the values section of the format pane

Submitted by on ‎01-19-2022 12:31 PM

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...

dsmithchildren_0-1642622925506.png

dsmithchildren_1-1642622987032.png

dsmithchildren_2-1642623032053.png

 

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)...

dsmithchildren_3-1642623949859.png

 

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.

dsmithchildren_4-1642624115314.png

 

Status: Accepted

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

See more ideas labeled with:
13 Comments (13 New)
Comments
bonacuse
Frequent Visitor
‎05-14-2024 08:45 AM

Come on. Isn't anyone from Microsoft going to provide any update on the status of the fix for this two and a half year old bug? I create a lot of Matrix visuals using "Show on Rows", and the exports are all unusable. None of them look like the "Data with current layout".

dsmithchildren
New Member
‎05-14-2024 08:53 AM

Agreed...I am the original reporter of this bug and they "accepted" this bug in Jan 2022 I would assume to be worked on...but that was 28 months ago.

butters2
New Member
‎12-09-2024 12:59 AM

Would save me a lot of trouble if it would finally be fixed. One can only hope.

Idea Statuses