Forum Discussion
How to create dashboard on usage itself?
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….
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.
2 Replies
Usage reports can only be combined inside the workspace. If you want more than that you should consider using the tenant audit logs instead.
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.
