Forum Discussion
Paginated Reports Usage Metrics
Hello Everyone,
I have several workspaces that contain multiple "Paginated Reports," and from what I've found on the internet, it is not straightforward to see the usage metrics for these reports. Could someone help me to find the best way to obtain them?
Thanks
- Anonymous2 years ago
Hi, julsr
You can refer johnbasha33 reply, if it does not word, here are several ways to obtain usage metrics for paged reports in Power BI.
1.Audit Logs: 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
2.Power BI Premium Capacity Metrics Application: If you have access to Power BI Premium, the 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 BIBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
7 Replies
- johnbasha33
Super User
Tracking usage metrics for Paginated Reports in Power BI can indeed be a bit more challenging compared to interactive reports. However, there are a few methods you can use to obtain usage metrics for your Paginated Reports:
Power BI Service Usage Metrics:
- Navigate to the Power BI service (https://app.powerbi.com).
- Go to the workspace containing your Paginated Reports.
- Click on the "Reports" tab to view a list of reports in the workspace.
- Hover over the report you're interested in, and you should see options such as "View usage metrics" or "View report usage." Click on these options to access usage metrics specific to that report.
Power BI Audit Logs:
- Power BI audit logs contain detailed information about user activities, including report views, interactions, and accesses.
- You can use the Power BI Management PowerShell cmdlets or the Power BI REST API to retrieve audit log data.
- By filtering audit log data based on report IDs or names, you can track usage metrics for specific Paginated Reports.
Usage Metrics APIs:
- Power BI provides REST APIs that allow you to programmatically retrieve usage metrics for reports, including Paginated Reports.
- You can use the Reports API to get report usage metrics, such as views, renders, and interactions.
- By querying the API for usage metrics specific to your Paginated Reports, you can obtain detailed usage data for analysis or reporting purposes.
Custom Tracking Solutions:
- If the built-in options are not sufficient for your needs, you can consider implementing custom tracking solutions.
- For example, you can embed Paginated Reports in custom web applications using the Power BI Embedded service and track user interactions using application analytics tools or custom logging mechanisms.
Third-Party Monitoring Tools:
- Some third-party monitoring and analytics tools provide integration with Power BI and offer enhanced usage tracking and reporting capabilities.
- These tools may offer features such as real-time monitoring, advanced analytics, and custom dashboards for tracking Paginated Report usage.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
- AnonymousNot applicable
Hi, julsr
You can refer johnbasha33 reply, if it does not word, here are several ways to obtain usage metrics for paged reports in Power BI.
1.Audit Logs: 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
2.Power BI Premium Capacity Metrics Application: If you have access to Power BI Premium, the 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 BIBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- julsr
Continued Contributor
Thanks you both johnbasha33 and Anonymous .
Is thr Power BI Premium Capacity Metrics Application exclusive for Power BI Premium or PowerBI Embedded has it too? I'm using PPU licenses and one embedded license but I can't see the option to enable this.
- AnonymousNot applicable
Hi, julsr
Power BI Premium Capacity Metrics App for Power BI Premium and Power BI Embedded, administrators will need to install this Apps to use it, you can refer to the link below for the detailed procedure.
Related link: Introducing Power BI Premium Capacity Metrics App as a template app | Microsoft Power BI Blog | Microsoft Power BIBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum