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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
learner03
Post Partisan
Post Partisan

Extract report

I made below report as matrix and shared with the user. The user wants to extract the report as it is but when I click export data it comes as table with 4 columns as-code, colour, size, numbers and not in this view as a matrix. How can this be extracted?

akapoor03_0-1632105583235.png

 

4 REPLIES 4
jdbuchanan71
Super User
Super User

The user will either need to use the report in the powerbi service or extract the data and rebuild it in a pivot table or, if you have enabled it, they can use analyze in excel to connect to the data model.  They can build a view that links to the model so when the model is refreshed they can just refresh their view.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

 

jdbuchanan71
Super User
Super User

The report cannot be extracted as is (in a matrix visual).  They can use the data that comes out to rebuild the visual in a pivot table though since that is all a matrix is.  One caveat to this is if you have a non-additive measure (something like distinct count), the totals on the pivot table will be wrong, they will be to high.

@jdbuchanan71 Till now the user was doing mannual analysis daily with downloading a report and using pivot table. But, to make the user's process automated, I built this report. What is the work around if the user wants this view?

Hi  @learner03 ,

 

Does user need to rebuild the report or just use the matrix visual?Will export to PDF or PPT a good option?

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-export-to-pdf

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-powerpoint

 

Best Regards,
Kelly

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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