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

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

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

 

Highlighted
Frequent Visitor

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

not what i expected

Highlighted
New Member

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

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.

Highlighted
Regular Visitor

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

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

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

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
Regular Visitor

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

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

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