Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
We have been running a monthly process to audit what report pages are being used in our environment. This is primarily to help determine if a report page is worth maintaining or the use case needs to be reinvestigated. Currently we're getting this data each month manually by going to the report's Usage Metrics Report then switching to the "Pages" view of the User/Pages utilization chart (bottom right corner), expanding this to the next level down so it shows users per page then exporting this data. Doing this by report is tedious but it has given us page utilization over time so we can ask key users about report pages.
I recently stumbled onto the Purview Audit log's ability to surface user level report access. It looks like it's so close to being able to reproduce my above process across our entire tenant and save me oodles of time, but it does not surface which pages are accessed. It stops at the report level. Am I missing something or is there another place that I can go to find this? It looks like I can audit report page prints but not views. I don't care about prints at this point, but it seems like to get to printing a report page, I'd need to access the report page so the data must be there.
This thread from a year ago doesn't instill me with much hope.
Solved! Go to Solution.
There is a work around on the out-of-the box usage report where you are currently viewing the Users/Pages. When you make one, it is initially for that one specific report, however, you can quickly turn it into a report that is for the entire workspace (still not as convenient as the entire tenant, but at least it is the entire workspace). When you go to a workspace, click on the three dots next to a report and click View usage metrics report. Then, when the report is generated, go into it. Click File and then click Save a copy. This will save it to that workspace. Next, open the filter pane and clear out the filter on ReportGuid. Then, save the report again so that this change is saved. Viola! The report is now for the entire workspace. If you want to look at it by report, just filter to whichever report you want.
Proud to be a Super User! | |
There is a work around on the out-of-the box usage report where you are currently viewing the Users/Pages. When you make one, it is initially for that one specific report, however, you can quickly turn it into a report that is for the entire workspace (still not as convenient as the entire tenant, but at least it is the entire workspace). When you go to a workspace, click on the three dots next to a report and click View usage metrics report. Then, when the report is generated, go into it. Click File and then click Save a copy. This will save it to that workspace. Next, open the filter pane and clear out the filter on ReportGuid. Then, save the report again so that this change is saved. Viola! The report is now for the entire workspace. If you want to look at it by report, just filter to whichever report you want.
Proud to be a Super User! | |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
33 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
37 | |
29 | |
14 | |
12 |