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