cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GDSHAW Frequent Visitor
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
Moderator v-qiuyu-msft
Moderator

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

21 REPLIES 21
Super User
Super User

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.
Moderator v-qiuyu-msft
Moderator

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

javihm77 Frequent Visitor
Frequent Visitor

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?

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.

kristof Frequent Visitor
Frequent Visitor

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.

kristof Frequent Visitor
Frequent Visitor

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
kristof Frequent Visitor
Frequent Visitor

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?

pierre-yves Frequent Visitor
Frequent Visitor

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

 

Deemah_EO Frequent Visitor
Frequent Visitor

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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)