cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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

29 REPLIES 29
Highlighted

making a pivot out of averages (calculated in PBI) make an average of averages instead of average of everything.. if it makes sence

 

Highlighted

not what i expected

Highlighted
New Member

Hi,

The best feature of this workaround is the use of PowerBI Publisher.

Where you need to connect and the data model to the excel and make the report in excel.

 

For any other reference, please check how PowerBI Publisher works.

Frequent Visitor

Hi all,

 

I wrote an in depth blog on this topic on my blog here: https://www.automationandinsight.com/index.php/2020/04/07/power-bi-export-woes/

 

Ultimately, this is a feature miss that Microsoft tried to stopgap with bolting on SSRS to Power BI in the form of paginated reports, and the workarounds are ugly and scary. It could be an opportunity to productize a hacky solution, but honestly I think that Microsoft needs to address this one, and I'll beat the drum for that.

Highlighted
Advocate III
Advocate III

I was able to export my pretty matrix visual by doing the following:

1. Created a table visual.

2. Created measures using calculate and filter to match the columns that were in the original matrix table.

3. Exported Data using elipses in upper right of table visual.

Highlighted

Can you share your example with the link. Tried doing that but couldn't

Highlighted

There are many custom visuals that other companies have created. I honestly cannot believe that neither Microsoft nor any other company have created a version of the matrix visual that can export to Excel while retaining the row hierarchy levels and column groups, as SSRS does.

Highlighted
Frequent Visitor

Hi Eyles,

 

I explored this and mentioned it briefly on the 4 part blog I wrote and posted to this forum. This is by design because custom visualizations utilize the Javascript API and the Javascript API has this limitation. Microsoft has to choose to "limit break" this.

Highlighted
Frequent Visitor

To resolve this I did the following:

  1. Created Measures for each column in the Matrix visual. 
  2. Used a Table visual instead of Matrix.
  3. exported data from table

I made a demo video here:

https://www.youtube.com/watch?v=bpwkUpxjH-E&feature=youtu.be

 

Highlighted

check out this video for a workaround: https://www.youtube.com/watch?v=bpwkUpxjH-E&feature=youtu.be

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors