Which Microsoft 365 services are your clients actually using, which ones sit idle, and where security adoption outpaces productivity tools. Generated by AI via Proxuma Power BI MCP server.
Which Microsoft 365 services are your clients actually using, which ones sit idle, and where security adoption outpaces productivity tools. Generated by AI via Proxuma Power BI MCP server.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: Microsoft 365 administrators, security teams, and account managers
How often: Weekly for license management, monthly for adoption reviews, quarterly for optimization
Which Microsoft 365 services are your clients actually using, which ones sit idle, and where security adoption outpaces productivity tools. Generated by AI via Proxuma Power BI MCP server.
EVALUATE
ROW(
"ServicesTracked", DISTINCTCOUNT(
'BI_Lighthouse_Service_Usage'[service_name]),
"PeakMAU", MAX(
SUMMARIZE(
'BI_Lighthouse_Service_Usage',
'BI_Lighthouse_Service_Usage'[service_name],
"svc_mau", CALCULATE(
SUM('BI_Lighthouse_Service_Usage'[monthly_active_users]))
),
[svc_mau]),
"TotalMAU", CALCULATE(
SUM('BI_Lighthouse_Service_Usage'[monthly_active_users]))
)All 10 tracked services ranked by cumulative monthly active users, with security vs productivity categorization
EVALUATE
TOPN(
10,
ADDCOLUMNS(
VALUES('BI_Lighthouse_Service_Usage'[service_name]),
"total_mau", CALCULATE(
SUM('BI_Lighthouse_Service_Usage'[monthly_active_users]))
),
[total_mau], DESC
)Aggregate MAU split by service category showing how security tools dominate the adoption landscape
| Category | Services | Total MAU | Avg MAU per Service | Share |
|---|---|---|---|---|
| Security | Intune, AADP, AADAuth, OATP | 886,319 | 221,580 | 48.0% |
| Productivity | Outlook, Exchange, OneDrive, Excel, Word, Teams | 959,407 | 159,901 | 52.0% |
EVALUATE
ADDCOLUMNS(
VALUES('BI_Lighthouse_Service_Usage'[service_name]),
"total_mau", CALCULATE(
SUM('BI_Lighthouse_Service_Usage'[monthly_active_users]))
)
ORDER BY [total_mau] DESC
-- Category grouping applied post-query:
-- Security: Intune, AADP, AADAuth, OATP
-- Productivity: Outlook, Exchange, OneDrive, Excel, Word, TeamsPaid SKU breakdown compared to service adoption to identify over-provisioning and under-adoption
| SKU | Consumed | Total | Utilization |
|---|---|---|---|
| SPE_E3 | 1,162 | 1,176 | 98.8% |
| FLOW_FREE | 728 | 10,000 | 7.3% |
| SPE_F1 | 603 | 612 | 98.5% |
| M365_F1_COMM | 209 | 224 | 93.3% |
EVALUATE TOPN(10, SUMMARIZECOLUMNS('BI_MicrosoftPartnerCenter_Subscribed_Skus'[sku_part_number], "ConsumedUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[consumed_units]), "TotalUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[total_units])), [ConsumedUnits], DESC)The most notable pattern in this data is the gap between security and productivity adoption. Intune leads all services at 278,206 cumulative MAU. AADP follows at 241,453 and AADAuth at 220,135. These are services that run in the background through policy enforcement. Users do not choose to adopt Intune. It gets pushed to their devices. That is exactly what you want from a security tool.
Productivity adoption tells a different story. Outlook and Exchange sit at roughly 200K MAU each, which makes sense because email is not optional. But from there, adoption drops sharply. OneDrive at 151K, Excel at 141K, Word at 130K, and Teams at 127K all sit well below the security services. These are tools that require deliberate user behavior, and many users either have not been trained on them or prefer alternatives.
Teams at 127,055 MAU is the single biggest adoption concern. With 1,162 E3 licenses in play, Teams should be the default collaboration platform. Instead, it has the lowest adoption of any tracked service. For MSPs managing hybrid or remote workforces, this is a missed opportunity. Teams adoption drives stickiness. Clients who use Teams heavily are less likely to churn because the switching cost is higher.
The license inventory shows 134 paid SKU types with 4,118 consumed seats. The spread across 134 SKUs suggests license sprawl. Most MSPs find that 10-15 SKUs cover 90% of their user base. A quarterly license audit comparing consumed seats to active usage could recover meaningful cost per user.
5 priorities based on the findings above
Teams has the lowest MAU of any tracked service despite being included in every E3 license. Identify tenants where Teams usage is below 30% of licensed seats and schedule onboarding sessions. Focus on the top 5 tenants by E3 seat count first because that is where the adoption gap has the largest absolute impact. A 20% increase in Teams adoption across 1,162 E3 users adds meaningful engagement and reduces churn risk.
134 SKU types across 4,118 consumed seats means the average SKU covers only 30 users. Pull a per-tenant SKU report and identify tenants running multiple overlapping licenses. Consolidating E1 + standalone add-ons into E3 bundles (or downgrading unused E3 to F3) can save $5-15 per user per month without reducing capability. Start with the "Other paid SKUs" bucket of 2,258 seats.
OneDrive should be the default storage layer for any M365-managed device. With Intune at 278K MAU and OneDrive at only 151K, roughly 45% of managed devices are not actively using OneDrive. This creates a data protection gap: files stored locally on Intune-managed devices are not backed up to the cloud. Enable OneDrive Known Folder Move via Intune policy to close this gap automatically.
OATP (Office Advanced Threat Protection) sits at 146,525 MAU, which is good relative to the overall user base but leaves a gap compared to Exchange at 202,213. Every user on Exchange should be covered by OATP. The 55,688 MAU difference between Exchange and OATP means there are email users without advanced threat protection. Cross-reference these numbers at the tenant level to find which clients have the gap.
Intune at 278K, AADP at 241K, and AADAuth at 220K prove that your managed clients have strong security coverage. These numbers belong in every sales pitch and TBR. Prospects want to know that their MSP enforces security, not just sells it. Build a one-pager showing security service adoption rates and include it in your standard proposal deck.
Proxuma Power BI pulls monthly active user (MAU) data from Microsoft 365 Lighthouse via the BI_Lighthouse_Service_Usage table. This data is aggregated across all managed tenants and broken down by service name. The AI then runs DAX queries to rank services, calculate totals, and compare categories.
Cumulative MAU is the sum of monthly active users across all reporting periods in the dataset. It reflects total usage volume over time, not a single month snapshot. A service with 278,206 cumulative MAU means that many user-months of activity have been recorded. To get a single-month figure, filter the DAX query by a specific date range.
Security services like Intune, AADP, and AADAuth are policy-driven. They activate automatically when a device is enrolled or a user signs in. Users do not opt in. Productivity tools like Teams or Word require deliberate usage. The gap between the two tells you how much of your security posture is enforced vs how much of your productivity suite is actually adopted by end users.
Add a GROUP BY on the tenant name column in the DAX query. The BI_Lighthouse_Service_Usage table contains a tenant identifier. Grouping by tenant and service name gives you a per-client breakdown. This is useful for identifying which specific clients have low Teams or OneDrive adoption and need targeted onboarding.
Yes. Connect Proxuma Power BI to your Microsoft 365 Lighthouse data, add an AI tool (Claude, ChatGPT, or Copilot) via MCP, and ask the same question. The AI writes the DAX queries, runs them against your real data, and produces a report like this in under fifteen minutes.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started