cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vmakhija Established Member
Established Member

Usage Metrics across workspaces

Hello,

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

 

Regards

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Usage Metrics across workspaces

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

View solution in original post

9 REPLIES 9
Community Support Team
Community Support Team

Re: Usage Metrics across workspaces

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

View solution in original post

gooranga1 Senior Member
Senior Member

Re: Usage Metrics across workspaces

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.

mgcharumilind Regular Visitor
Regular Visitor

Re: Usage Metrics across workspaces

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

gooranga1 Senior Member
Senior Member

Re: Usage Metrics across workspaces

Hi @mgcharumilind,

 

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. 

mgcharumilind Regular Visitor
Regular Visitor

Re: Usage Metrics across workspaces

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.

matei81 Frequent Visitor
Frequent Visitor

Re: Usage Metrics across workspaces

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?

 

image.png

 

UPDATE:

I found how it works here:

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

veeresh Frequent Visitor
Frequent Visitor

Re: Usage Metrics across workspaces

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.

felixthecoach Frequent Visitor
Frequent Visitor

Re: Usage Metrics across workspaces

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.

mgcharumilind Regular Visitor
Regular Visitor

Re: Usage Metrics across workspaces

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors