Build your own usage report with Power BI

Yesterday I found out we have a great feature in Power BI that everyone should know about but I stumbled upon by accident. it turns out you can create your own, fully customized, usage reports to share. I found it while going over the documentation right here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-usage-metrics/

So let’s get at it. I created this report:

image

Now I want to create a report that I can share with the sales team that shows how many users I have on this dashboard. First I click on the “Usage metrics“ at the top

image

That opens the out of the box report that comes with Power BI, the key here is that I also have ability to do “save as”

image

This now adds the report to my workspace that I can change how I want it:

image

But also it adds the Dataset to Power BI (UPDATE: This behaivor has changed as of 2019, the dataset doesn’t get added to the UI any more. The next steps are still possible though so this shouldn’t affect the rest of the post. )

image

This now allows me to connect to this dataset from PBI desktop as well:

image

And now I can do anything I want, use my own visuals, add new measures etc

image

Interesting to note here is that there is a single model for all the reports and another one for all the dashboards per workspace. This allows you to build some comprehensive reporting that you can share with stakeholders around a particular area.

Pretty cool right Smile

11 Replies to “Build your own usage report with Power BI

    1. This is reporting per workspace, for reporting on all workspaces you need to be Power BI admin. The idea is that this report will also become available there. If you don’t have access to another workspace you should also not be able to see the usage data I think.

  1. Hi,

    I was trying to do the same thing, however the dataset is not getting added. Is there anything specific I need to enable to get the dataset?

        1. I checked with the team, you are correct it doesn’t get added as a dataset anymore but you should see it when connecting from PBI desktop

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.