How to create dashboard on usage itself?

[Anonymous]

I have 4 reports in different workspaces. I want to create a dashboard on usage of it.

I know there is the (below) “View usage metrics report” option… but, I would like to combine all of them in one report.

Furthermore, I have a user dimension myself, that I would like to join to User Principal Name, and do different ‘group BYs’…

Is there a way of achieving it? I am trying to find a way of either exporting it to my sql server database and then create an ssas cube… or somesort of upload my user dimension and create a dataflow in the power bi service….

[lbendlin]

Usage reports can only be combined inside the workspace.  If you want more than that you should consider using the tenant audit logs instead.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can grab the activity logs from the O365 Management API and load the results into a Power BI Streaming Dataset.

You can refer to this blog:

https://www.proserveit.com/blog/power-bi-usage-metrics-across-all-workspaces 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.