Forum Discussion

ashleyrando's avatar
ashleyrando
New Member
1 year ago
Solved

Paginated report usage metrics

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 fo...
  • pborah's avatar
    pborah
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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 | Microsoft Power BI Blog | Microsoft Power BI

     

     

    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.