Report Usage Metrics combined for multiple reports in multiple workspaces

[Anonymous]

I have couple of premium workspaces and in each of them multiple reports are published. I am looking to create one dashboard which should show the usage metrics for each of these reports. It should show the option to select the workspace/report in the drop down and data should be shown accordingly. This might be achievable by reading the power BI logs and save it as a csv and then read that csv to create this dashboard. Per my understanding, the report usage metrics option which is available in power BI is at each report level and hence this requirement will have to be achieved by writing a power shell script. I found few approaches (links below) but it requires couple of elevated access (admin level). Kindly advise if there is a better way to achieve this.

https://docs.microsoft.com/en-us/power-bi/service-admin-auditing#requirements

https://www.youtube.com/watch?v=fC6SK2TkoS0

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

First, to my knowledge, it is not available that combine Report Usage Metrics of report across different workspace.

and you may try to extract the Audit Log from O365 Admin center by manually or powershell and do it in power bi desktop.

here is a blog for you refer to:

https://radacad.com/build-your-own-power-bi-audit-log-usage-metrics-across-the-entire-tenant

and for elevated access problem, you need to check your account permission in O365.

Best Regards,

Lin

[Anonymous]

thanks for the reply @v-lili6-msft , even i found similar ways to do this.

However in our organization giving the admin access at office 365 or power BI level is a limitation.

If we want to create a usage metrics within one dashboard and multiple reports, can this be done without this elevated acess?

[v-lili6-msft]

hi, @Anonymous 

To my knowledge, it couldn't achieve that get it without this elevated acess.

For your requirement, you can vote for ideas below:

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

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

Best Regards,

Lin