If you create dashboards and reports, usage metrics help you understand their impact. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization; what is being used, by whom, and for what purpose.
These usage metrics reports are read-only. However, you can personalize a usage metrics report by using "Save as." This creates a brand new dataset and converts the read-only report to a full-featured Power BI report that you can edit. Not only does the personalized report contain metrics for the selected dashboard or report, but by removing the default filter, you now have access to usage metrics for all dashboards or all reports in the selected workspace.
Knowing how your content is being used helps you demonstrate your impact and prioritize your efforts. Your usage metrics may show that one of your reports is used daily by a huge segment of the organization and it may show that a dashboard you created isn't being viewed at all. This type of feedback is invaluable in guiding your work efforts.
Running usage metrics reports is only available in Power BI service. However, if you save a usage metrics report or pin it to a dashboard, you will be able to open and interact with that report on mobile devices.
NOTE: The usage metrics feature captures usage information from all users, both Free and Pro. However, a Pro license is required to run and access the usage metrics data. This feature does not expose the names or email addresses of the users.
Usage metrics are provided on dashboards or reports in the selected workspace. To get access to usage metrics data for a particular dashboard or report, you must:
• Have edit access to that dashboard or report
• Have a Pro license
When you select Usage metrics or the icon , Power BI generates a pre-built report with usage metrics for that content for the last 90 days. The report looks similar to the Power BI reports you're already familiar with, but it's designed to be informational -- not interactive. You’ll be able to slice based on how your end users received access, whether they were accessing via the web or mobile app, etc. As your dashboards and reports evolve, so too will the usage metrics report, which updates every day with new data.
Usage metrics reports won't show up in Recent, Workspaces, Favorites, or other content lists. They cannot be added to an app. If you pin a tile from a usage metrics report to a dashboard, that dashboard cannot be added to an app or content pack.
To dig down into the report data, or to build your own reports against the dataset, use Save as (see Save the Usage Metrics report as a full-featured Power BI report.
Start in the workspace that contains the dashboard or report.
From either the workspace content list or from the dashboard or report itself, select the icon for Usage metrics .
The first time you do this, Power BI creates the usage metrics report and lets you know when it's ready.
To open the results, select View usage metrics.
Usage metrics will be a powerful ally as you work to deploy and maintain Power BI dashboards and reports. Wondering which pages of your report are most useful, and which ones you should phase out? Slice by report page to find out. Wondering if you should build a mobile layout for your dashboard? The usage metrics report will inform you how many users are accessing your content via the mobile apps vs. via web browser.
Optionally, pin visualizations to a dashboard so you can monitor them more-easily or share them with others.
NOTE: If you pin a tile from a usage metrics report to a dashboard, that dashboard cannot be added to an app or content pack.
|Distribution method slicer||yes||yes||How users got access to the content. There are 3 possible methods: users can access the dashboard or report by being members of an app workspace, by having the content shared with them, or by installing a content pack/app. Note that views through an app are counted as "content pack."|
|Platforms slicer||yes||yes||Was the dashboard or report accessed via the Power BI service (powerbi.com) or a mobile device? Mobile includes all our iOS, Android, and Windows apps.|
|Report page slicer||no||yes||If the report has more than 1 page, slice the report by the page(s) that was viewed. If you see a list option for "Blank," that means a report page was recently added (within 24 hours the actual name of the new page will appear in the slicer list) and/or report pages have been deleted. "Blank" captures these types of situations.|
|Views per day||yes||yes||Total number of views per day - a view is defined as a user loading a report page or dashboard.|
|Unique viewers per day||yes||yes||Number of different users who viewed the dashboard or report (based on the AAD user account).|
|Shares per day||yes||no||Number of times the dashboard was shared with another user or group.|
|Total views||yes||yes||Number of views in the past 90 days.|
|Total viewers||yes||yes||Number of unique viewers in the past 90 days.|
|Total shares||yes||no||Number of times the dashboard or report was shared in the past 90 days.|
|Total in organization||yes||yes||Count of all dashboards or reports in the entire organization which had at least one view in the past 90 days. Used to calculate rank.|
|Rank: Total views||yes||yes||For total views of all dashboards or reports in the organization over the past 90 days, where does this dashboard or report rank.|
|Rank: Total shares||yes||no||For total shares of all dashboards in the organization over the past 90 days, where does this dashboard or report rank.|
Use Save as to convert the usage metrics report to a full-featured Power BI report that can be customized and shared. Once you’ve created a personalized copy, you’ll get full access to the underlying dataset, allowing you to fully customize the usage metrics report to your specific needs. You can even use Power BI Desktop to build custom usage metrics reports using the live connection to Power BI service feature.
Better yet, the underlying dataset includes the usage details for all dashboards or reports in the workspace. This opens up yet another world of possibilities. You could, for example, create a report which compares all dashboards in your workspace based on usage. Or, you could create a usage metrics dashboard for your Power BI app by aggregating usage across all the content distributed within that app. See remove the Page level filter below.
When Power BI creates the full-featured report, it also creates a new dataset made up of all the dashboards or all the reports contained in the current workspace that have been accessed in the last 90 days. For example, say you have a workspace named "Sales" and it contains three dashboards and two reports, and you create a usage metrics report on the "Northeast" dashboard. And then you use Save as to personalize and convert it to a full-featured report. The dataset for that new report contains the usage metrics not only for that one dashboard named "Northeast" but for all three dashboards in the "Sales" workspace. By default, the report will display data for the "Northeast" dashboard and you'll need to remove a filter (single click) to display data for all three dashboards.
When you create a copy using "Save as" (personalize), Power BI converts the read-only pre-built report to a full-featured report. At first glance, it looks exactly the same. However, you can now open the report in Editing view, add new visualizations, filters, and pages, modify or delete existing visualizations, and so much more. Power BI also creates a brand new dataset that contains usage metrics for all dashboards or all reports in that workspace.
TIP: To allow Power BI to access usage metrics for all dashboards or all reports in the workspace, remove the Page level filter.
From the pre-built usage metrics report, select File > Save As. Power BI converts the usage metrics report into a full-featured Power BI report. This is called a personalized usage metrics report.
Open the report in Editing view and interact with it as you would with any other Power BI report. For example, add new pages and build new visualizations, add filters, format the fonts and colors, etc.
Alternately, open the new dataset and build a report from scratch.
The new report is saved in the current workspace and also added to the Recent content list.
To see the metrics for all the dashboards or for all the reports in the workspace, you'll have to remove a filter. By default, the personalized report is filtered to display metrics for only the dashboard or report that was used to create it.
If, for example, you used the dashboard named "European sales" to create this new personalized report, only usage data from the "European sales" dashboard will display. To remove the filter, and enable data from all the dashboards in that workspace:
Open the personalized report in Editing view.
In the Filters pane, locate the Report level filters bucket and remove the filter by selecting the "x".
Now your personalized report displays metrics for the entire workspace.
Usage metrics reports are a feature that the Power BI or Office 365 administrator can turn on or off; they are On by default.
Open the Admin portal by selecting the gear icon in the top-right-corner of Power BI service and choosing Admin portal.
From the Admin portal, select Tenant settings and choose Usage metrics for content creators.
Enable (or disable) usage metrics and select Apply.
Q: I can't run usage metrics on a dashboard or report
A: You can only see usage metrics for content you own or have permissions to edit.
Q: I can't run usage metrics on any content at all.
A1: Admins can turn off this feature for their organization. Contact your Admin to see if this is the case.
A2: Usage metrics is a Power BI Pro feature.
Q: The data doesn't seem up-to-date. For example, distribution methods don't show up, report pages are missing, etc.
A: It can take up to 24 hours for data to update.
Q: There are four reports in the workspace but the usage metrics report only displays 3.
A: The usage metrics report only includes reports (or dashboards) that have been accessed in the past 90 days. If a report (or dashboard) does not show up, likely it hasn't been used in more than 90 days.
More questions? Try the Power BI Community