Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Usage Metrics - Create Custom Usage report for non-admin users to see

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 rath...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Good night

    Try to paste in a dashboard the metricas (selecting from the 3 points ... the option "pin to a dashboard", so a dashboard is generated with the metrics of use of the report in question and to which all the people of your interest can have access.

    Best regards

    Juan