Usage Metrics across workspaces

[vmakhija]

Hello,

Is it possible to modify usage metrics report which can access reports/dashboards across multiple workspaces?

Regards

[Alina_Fisher]

Hey, if you're not an admin, you can try solution from this article!

Let's you get usage data from any workspace and combine it together in automated way.

Article on linkedin - https://www.linkedin.com/pulse/automate-power-bi-usage-data-across-workspaces-using-paginated-alina/

Please mark this answer as solution if it helped you!

Thank you

[gooranga1]

This would really be helpful as the number of our workspaces increases and we are getting asked consistently what the usage is across the company. Currently a painful excercise.

[Anonymous]

I think this capability was just added very recently. I just found this https://docs.microsoft.com/en-us/power-bi/service-usage-metrics which says "...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. And you can even see the names of your end users."

[veeresh]

Hi Team,

I can customize the usage report for a particular workspace but I need to combine for all the workspaces across the company so that I can have a single usage report for all the reports available in my company. 

Is that possible and how can I do it.

Note: I have already customized the usage report for a single workspace.

[Anonymous]

If you use Power BI Report Builder, it's possible to directly import the usage metric reports after connecting to the workspace. You can then import all usage metric datasets into the same report and visualize them together in the Power BI Report builder. If you're saavy enough, you could even export that to CSV and import the results to a new Power BI view or use some tricks to create a new Dataset. It's a silly workaround, but it would get what you're looking for.

[Anonymous]

Yes, it is possible, and I think that is how we (really https://twitter.com/pjraduta) ultimately did it! 

[matei81]

I am using this (Remove the filter to see all workspace usage metrics) tutorial but I have no 'Edit' option on Report/Dashboard Usage Metrics.

Can anyone please help?

UPDATE:

I found how it works here:

https://powerbi.tips/2017/11/custom-usage-metrics-reporting/

[gooranga1]

Hi @Anonymous,

Yes we have modified the usage to encompass the whole workspace and add better metrics for us. It has been around a little while now. The big but though is that I want to report across all workspaces as well so we can review licenses at a corporate level. 

At the moment I have to export all the individual workspaces usage report from a specific matrix I create in each report and analyse it in excel to get a company wide view of usage across all workspaces as a whole. So we check last usage and I need to know that across all our different workspaces. 

[Anonymous]

Yes, we are doing the same thing and will continue to. In addition to looking across workspaces, we want to keep historical data beyond 90 days and exporting it to Excel seems to be the only way to do that at the moment. We then combine the usage data with other tables, which cannot be done with the report provided in Power BI either. So, it's a bit better that we can view all report usage for a workspace in one place, but it still isn't everything we need.

[v-yuta-msft · Accepted solution]

Hi vmakhija,

If you are a Power BI admin, you can go to Admin Portal-> Usage Metrics to see which users and groups, are the most active within Power BI for your organization. This will not show detail information as in report/ dashboard usage metrics.

For your requirement, you can vote for ideas below:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19593388-custom-usage-reporting-a...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33678364-standard-usgae-metrics-r....

Regards,

Jimmy Tao