Paginated report usage metrics

[ashleyrando]

We are in the process of migrating from on prem reporting to PowerBI. We have over 1000 paginated reports that we will be moving to powerBI workspaces. I understand there are default usage metrics for reports and dashboards but these are unavailable for paginated reports. We have looked into Purview and Log Analytics Workspaces but neither of these seem to give us usage metrics for our paginated reports. It's possible we are missing some steps in setting up Purview/Log Analytics, but there isn't much information out there specific to paginated reports. We have enabled Azure Log Analytics on several workspaces, but logs do not appear to make it to Azure when reports are run from the PowerBI Service. Does anyone know where these logs land and how to access them?

[pborah · Accepted solution]

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

[Anonymous · Accepted solution]

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.

Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app | Micros...

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.

[pborah]

hi @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.

[ashleyrando]

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 · Accepted solution]

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