usage metric reports all in one place

[kkalyanrr]

Hello Team,

Is there a way I can prepare usage metrics reports of all apps in my organization in to one workspace.So that I can build a master dashboard of all apps users and details.

Thanks.

[v-eqin-msft]

Hi @kkalyanrr ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @kkalyanrr ,

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

Refer to :

Power BI Usage Metrics Across All Workspaces

Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD

Track user activities in Power BI - Power BI | Microsoft Docs

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

[kkalyanrr]

@ibarrau  Can please provide more information about the Rest API

[ibarrau · Accepted solution]

Sure.
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/getactivityevents

Good luck!

[ibarrau]

Hi. Yes. You can get data from Power Bi Rest API to get the logs of usage metrics in order to build a custom report. I would suggest creating an historical data source with a different tool and then get data with Power Bi. The API has a limit of 90 days of data. 

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/getactivityevents

Hope that helps,