Forum Discussion
New Usage Metrics - Create Custom Usage report for non-admin users to see
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.
Regards,
Pat
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.
Griffin