topic Re: How to create dashboard on usage itself? in Developer

How to create dashboard on usage itself?

Anonymous — Wed, 02 Mar 2022 14:02:28 GMT

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….

Re: How to create dashboard on usage itself?

lbendlin — Thu, 03 Mar 2022 20:04:17 GMT

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

Re: How to create dashboard on usage itself?

V-lianl-msft — Mon, 07 Mar 2022 07:42:34 GMT

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.