Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
s240105
New Member

How to export matrix data in same format and not transposed?

On Power BI, When I export matrix data it downloads transposed, not with the original format, so in Excel file, I must transpose it again.

Is there a way on exporting matrix data with the same format and not be transposed?

4 REPLIES 4
v-kpoloju-msft
Community Support
Community Support

Hi @s240105,

Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to @Royel@MFelix, for those inputs on this thread. Here I provided some official Microsoft links those might be helpful to resolve your thread more quickly.

This issue occurs because Power BI's export behaviour for Matrix visuals varies depending on how you are exporting (e.g., "Underlying data" vs "Summarized data") and whether the matrix contains nested rows/columns, values on rows, or measures. In most export scenarios, Power BI flattens the matrix into a tabular structure for compatibility with Excel often resulting in an unintuitive, transposed-looking layout.

I understand you are facing an issue where exporting a Matrix visual result in the data being transposed in Excel, not matching the visual layout. This happens because Power BI usually flattens matrix data during export. 

To get the export in the same layout as your Matrix, here's what you can do: If you are using Power BI Service, export the data using the "Data with current layout" option this keeps the rows, columns, and layout exactly as displayed.  Note: This only works in Power BI Service not in Power BI Desktop.

Alternatively, try "Analyse in Excel" to get even more layout control directly in Excel via a pivot-style setup.

If you are using Power BI Desktop, the export will always flatten the matrix as a workaround, you could recreate the layout using a Table visual for better export consistency.

Also kindly refer to the below mentioned documentation links for better understanding:
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Export data from a Power BI visualization - Power BI | Microsoft Learn

Let me know which version you are using (Desktop or Service), and I can guide you further.
Thank you for using the Microsoft Community Forum.

Hi @s240105,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

Royel
Resolver II
Resolver II

Hi @s240105 you can try with Data with Current Layout option 

Steps:

  1. Select the matrix visual and click on the "..."
  2. Select "Export data"
  3. Data with current layout
  4. Click "Export"

Royel_0-1753129991173.png

Only the limitation is its only accept 150,000 data intersections. https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d... 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!


 

MFelix
Super User
Super User

Hi @s240105 for this you need to allow users to export summarize data:

 

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

 

Follow this documentation and you should be able to get what you need.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.