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

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

7 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.

Leave a Reply

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