cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

I want Export data of matrix visual in matrix form not in tabular form.

I am using matix visual, with fields ( Row = Member name, column = Date and value = Spent hours ) and i am getting the data  in matrix format perfectly (in power BI desktop/ services). But when I export the same to excel, I get it in tabular form. Is it possible to get the excel file in the same format as showing in power bi desktop/services( matrix form).

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: I want Export data of matrix visual in matrix form not in tabular form.

Hi @GDSHAW,

 

In Power BI, Export Data feature is used for exporting data, without keeping visual format in .CSV file currently. You can take a look at this article: Export data from Power BI visualizations.

 

To work around the issue temporarily, you can use @MattAllington's suggestion to create a PowerPivot table in Excel. Or you can use PowerBI Tiles add-in in the Excel to get matrix visual. See: Integrating Power BI Tiles into Office documents.

 

Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

25 REPLIES 25
Highlighted

Re: I want Export data of matrix visual in matrix form not in tabular form.

Yes, this export feature seems a bit immature. Can you throw a pivot table over it in Excel?



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Community Support
Community Support

Re: I want Export data of matrix visual in matrix form not in tabular form.

Hi @GDSHAW,

 

In Power BI, Export Data feature is used for exporting data, without keeping visual format in .CSV file currently. You can take a look at this article: Export data from Power BI visualizations.

 

To work around the issue temporarily, you can use @MattAllington's suggestion to create a PowerPivot table in Excel. Or you can use PowerBI Tiles add-in in the Excel to get matrix visual. See: Integrating Power BI Tiles into Office documents.

 

Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate II
Advocate II

Re: I want Export data of matrix visual in matrix form not in tabular form.

this feature seems to be unmature, I tried to export to CSV the matrix as seen in PI but it exports all hiearchy levels, did someone found how to solve it?

Highlighted
Anonymous
Not applicable

Re: I want Export data of matrix visual in matrix form not in tabular form.

What happened to this? It seems like you still cannot export a matrix table to excel and keep the visual intact. This is absolutely embarassing and very frustrating.

Highlighted
Advocate I
Advocate I

Re: I want Export data of matrix visual in matrix form not in tabular form.

I agree! It does not make sense that a complex beautiful matrix/table/... can be shown in PowerBI, but that you need to redo quite some modelling when you export to excel.

 

I get this is the case for some complex visuals, but even a simply table cannot be exported as such. Doing certain manipulations completely in PowerBI is not always very efficient (and you need more rights to the sourcefile). And creating a pivot is fine, but for very large datasets, you are draining time and resources, for computations that were already done.

Highlighted
Advocate I
Advocate I

Re: I want Export data of matrix visual in matrix form not in tabular form.

I agree! It does not make sense that a complex beautiful matrix/table/... can be shown in PowerBI, but that you need to redo quite some modelling when you export to excel.

 

I get this is the case for some complex visuals, but even a simply table cannot be exported as such. Doing certain manipulations completely in PowerBI is not always very efficient (and you need more rights to the sourcefile). And creating a pivot is fine, but for very large datasets, you are draining time and resources, for computations that were already done.

Highlighted
Advocate I
Advocate I

Re: I want Export data of matrix visual in matrix form not in tabular form.

This is not a solution. You might be exporting the 'summarized data', but you still have all the details. I'm looking at a table with 5 columns and about 30 rows in PowerBI, but the export contains all data (just filtered on columns and rows). Not fun to redo a summarized view based on a few tens of thousands of rows again.

 

Extracting a table, just at it looks like in PowerBi cannot be that hard right?

Highlighted
Advocate I
Advocate I

Re: I want Export data of matrix visual in matrix form not in tabular form.

I m clearly interested by such features.

 

It s a waste of time to format a new pivot table in xls when everything is done in power BI

 

Highlighted
Advocate I
Advocate I

Re: I want Export data of matrix visual in matrix form not in tabular form.

This feature should added to Power Bi , we need it soo much !!!!

Please add it to the next update !!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors