Usage Metrics or Do It Yourself Power BI Monitoring Report

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

One of the features of Power BI Service is usage metrics report on a dashboard or report. The usage metrics report will give you an analysis of how many times the content is viewed or share, through which platforms, and by which users. You can also create your own monitoring report based on the model of usage metrics. In this post, I’ll explain how easy is to use the usage metrics, or even creating your own report from it. If you want to learn more about Power BI, read Power BI book from Rookie to Rock Star.

Usage Metrics

The usage metrics report in the Power BI service will give you some analysis on the views and shares of the Power BI content. This report can be turned off or on in the Power BI Administrator tenant setting configuration. You can also choose if you want the individual per-user data analysis for that to be visible or not, this configuration can be also determined in the tenant settings.

The report has a number of sections which mainly explains to you how users consumed this report, you can slice and dice by Distribution methods (sharing, workspace), or by Platform (Mobile, Web). The report gives you an overall analysis as well as a per day analysis.  Here is a look and feel of a usage metrics report;

You can access the usage metrics report by clicking on the Usage Metrics icon;

Do It Yourself!

You can create your own version of usage metrics report if you want. You just need to use the existing model and build visualization on top of it. To start, you need to create a copy of the usage metrics report. For doing this, open the usage metrics report, and then click on File, and Save As

Save the new report with a different name, and then open it. You can now see and click on the Edit option on the top of the report

When you go to Edit mode, then see the tables and fields in the dataset that has the monitoring information.

You can even remove the existing Report level filter to bring monitoring data for all reports and dashboards.

Everything after this step depends on your creativity to create your report with whatever visuals you want. Here is an example of usage metrics report version I have created in few minutes;

As you can see the report include all dashboards. I can click on a dashboard in the slicer, and see the detailed monitoring analysis of that content.

Summary

This was a very quick post about using the Usage Metrics report in Power BI service or even creating your own version of the monitoring report.

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

8 Comments

  • Hi,

    Thanks for your grear blog post!
    One question, you worte:

    Unfortunately, you cannot download this report in Power BI Desktop at the moment

    Isn’t it possible to connect to this data-set using get data – power bi service

    than you can work on PBI Desktop.

  • Hi Reza,
    I was able to use the desktop to create my statistics report. I simply selected the Power BI Service using Get Data. The Report Usage Metrics Model is an available selection.

    • Hi.
      Yes, you can work with it from “Get data from Power BI Service” of Power BI Desktop. However, what I meant by “You are not able to work with it from Power BI Desktop”; was ability to change the data model. You can connect to it from Desktop, but that would be a live connection.
      Cheers
      Reza

  • Power BI Desktop has a connector to the Power BI service where you can select the Report Usage Metrics Models to pull report/user/view data for a specific workspace. I’ve used this method before to allow development of the visuals in PBI Desktop.

  • This is great. But if I want to see the Usage Analysis for all the dashboards/reports including all the workspace. Is there any way to do ?
    The above explanation works fine if we want to track usage of all the dashboard/reports within a workspace.
    However, at org level, we may want to see the entire usage.

Leave a Reply

Your email address will not be published. Required fields are marked *