Forum Discussion
Paginated report usage metrics
ashleyrando if you are the capacity admin, or even better- a global admin, you should be able to utilize the canned dashboards for capacity utilization metrics. If you're neither of those admins, the farthest you will get is having an inventory of your entire tenant, provided you're atleast a workspace admins in all of your organization's workspaces. It seems even for Purview you need to be a fabric admin.
Thanks for pborah's concern about this issue.
Hi, ashleyrando
I am glad to help you.
You can refer pborah's solution, if it does not work, here are several ways to obtain usage metrics for paged reports in Power BI.
You can use Audit Logs to extract Power BI log information (audited reports or dashboards) and then filter individual report usage to get the desired results.
Additionally, you can create Powershell scripts to extract audit logs into CSV files and then use the CSV files as a data source for Power BI reports.
Solved: Paginated Reports - Usage Metrics - Where are they... - Microsoft Fabric Community
Solved: Paginated Reports Usage Metrics - Microsoft Fabric Community
If you have access to Power BI Premium, the Power BI Premium Capacity Metrics application provides detailed metrics on the performance of paged reports within a capacity.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution Sagehi ashleyrando one of the easy cheap tricks to do this is to add a dummy pbix report to each of the production workspaces where a bunch of your paginated reports will live but not make that report available to the end users, i.e. exclude it from the final app. That way you can go to the production workspace and view the usage metrics report for that dummy report. But in that same report one of the tabs will be called "Report List" which will show all reports in that workspace and contain usage details for all of them including your paginated reports.
In the screenshot below, the reports I masked out in grey are paginated reports whereas the two in purple are Power BI reports. I opened a usage metrics report for the ones in purple but it also gives me metrics for my paginated reports in the "Report List" tab.
Thanks for your reply! We'll have about 50 workspaces, so our hope was to have one report we could pull to show usage metrics across all workspaces. Azure Log Analytics looked promising but we can't seem to get it to work.
I've also been able to run some queries in Purview which seems to have the data I need, but now we need to get that data out of Purview and into a table we can query and build reports on.
- pborah
ashleyrando if you are the capacity admin, or even better- a global admin, you should be able to utilize the canned dashboards for capacity utilization metrics. If you're neither of those admins, the farthest you will get is having an inventory of your entire tenant, provided you're atleast a workspace admins in all of your organization's workspaces. It seems even for Purview you need to be a fabric admin.