I am trying to create a custom usage report using the new (Jan 2020+) usage metrics data for non-admins to use. I did this with the old usage metrics report, and though the process I created was rather clunky, it worked. But I am having problems doing the same thing with the new metrics data. Here are the issues I am trying to solve:
With the previous usage reports, I manually downloaded the usage data to CSVs and uploaded them to a SQL database on a near-daily basis. I created a Custom Power BI report from that data and published it in a separate Workspace and gave Managers access to that workspace App. Like I said, a little clunky, but it worked. (If you know of a better/more automated way to accomplish this, I would love to get suggestions, but that is not my immediate problem) This process also allows us to maintain usage stats beyond the 90 day window (new stats are only for 30 days, apparently).
Here's my issue with the new usage metrics: Almost all of the visuals in the new Usage report use new Measures that are in the Metrics dataset. (The previous usage metrics did not use Measures.) But, while I can download the Table data, I can not see or download the Measures, and I can't create a similar usage report without the measures. I have tried to re-create the measures but have not been able to come up with measures that show data that matches the built-in usage report. (There are over 50 measures, but not sure if I need them all for the custom report.)
Does anybody know how I can replicate the hidden measures in the new usage metric dataset? Or, alternatively, Is there a way to publish the Usage Metrics so that non-admins to the workspace can use them?
Thanks for your help,
So can you not download the pbix from the published report/dataset? Or can get an admin to do that for you once? That would contain all the measures, and you could get them out one by one (or use one of the PBI tools to bulk extract them).
For your daily tasks moving files around, I'm guessing Power Automate could help you there, but I don't know the details of what you are doing.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Thanks for the reply. The Usage Metrics Dataset that PBI creates is not available/visible in the workspace, it is completely hidden. You can link a new PBI report to it and use the data (if you are an admin), but you cannot see the dataset or download it. I am Admin for the workspace, so I can see the data, but non-admins cannot.
I will check out Power Automate. It sounds familiar, I think I checked it out when I first did this a year or so ago, but I will check it out again.
Hi @GriffinW ,
To convert the usage metrics report to a regular Power BI report that you can customize to meet your specific needs following methods below.
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. My problem was not how to create a custom metrics report - I know how to do that. As I stated in my post title, I need to create a report that non-admins to the workspace can see. (I have several managers/executives in the company that want to see the usage of my reports.) Even if I publish my custom report to another workspace, it links to the original workspace metrics dataset, which only admins have permission to see, so the report comes up blank for them. That dataset is invisible, so cannot be downloaded/viewed/changed or permissions changed.
I would think this would be a common requirement - my boss (and their boss, and their boss) want to know if anybody is using the reports that the company is paying me to create. Part of my job performance evaluation is to show whether my reports are useful or not. Taking daily or weekly screenshots of the metrics, which I do now, is not a very good solution, and, of course, does not allow the person to filter the report at all.
Thank you for any help you can provide.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.