Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
hi,
I need to know what options are available to download monthly O365 Apps usage data either with API or PowerShell commands.
Microsoft M365 Usage report has limitation of data available only for 12 months also data is not co-related to all the employees, I need to know if it is possible to extract monthly usage data of all the apps where I can map it with current employees.
Please help.
Thanks @Greg_Deckler
If possible can you share documentation or any link, that would be helpful.
@aakif_aslam Sure, View audit logs - Power BI | Microsoft Learn
@aakif_aslam Well the Office 365 Audit logs are the best source for this kind of data, you could download at regular intervals and use incremental refresh to build up as much history as you want. Could also connect to the AAD Graph API to correlate with employees.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 51 | |
| 44 | |
| 43 | |
| 39 | |
| 32 |