OneDrive for Business storage quotas troubleshooting for Microsoft 365 admins: show missing users

As a Microsoft 365 admin, you may notice that some users do not appear in the OneDrive storage quotas report in the admin center. This can make it difficult to track storage consumption or enforce quota limits across your tenant. The missing users are typically unlicensed users, users without a provisioned OneDrive site, or users whose accounts have not synced with the reporting service. This article explains why certain users are excluded from the storage quotas view and provides step-by-step methods to identify and resolve these gaps.

Why Users Are Missing from the OneDrive Storage Quotas Report

The OneDrive storage quotas report in the Microsoft 365 admin center relies on two conditions. First, the user must have an active OneDrive for Business license assigned. Second, the user must have a provisioned OneDrive site. A site is provisioned automatically when a user signs in to OneDrive for the first time or when an admin runs the OneDrive provisioning cmdlet. Users who have never signed in to OneDrive will not have a site and will not appear in the report. Additionally, the report only includes users whose accounts are synchronized with the OneDrive reporting service. This synchronization occurs within 24 to 48 hours after a new user is licensed or after a site is created. If you recently assigned licenses or created sites, those users may not appear until the next sync cycle completes.

Unlicensed Users

Users without an OneDrive for Business license are excluded from the storage quotas report. The report filters users based on license assignment, not on whether a site exists. To verify licenses, go to Microsoft 365 admin center > Users > Active users and check the Licenses and apps column for each missing user.

Users Without a Provisioned OneDrive Site

A licensed user will not appear in the storage quotas report until their OneDrive site is provisioned. Provisioning occurs automatically on first sign-in to OneDrive or when an admin uses the Request-SPOPersonalSite cmdlet. Users who have never accessed OneDrive or whose site creation was blocked by a policy will be missing from the report.

Delayed Reporting Sync

The storage quotas report updates every 24 to 48 hours. If you recently assigned a license or provisioned a site, wait at least two days before concluding that a user is permanently missing. You can force a refresh by running the Get-SPOSite cmdlet to check the actual site state.

Steps to Identify and Show Missing Users in OneDrive Storage Quotas

Use the following methods to locate users who do not appear in the admin center report and to ensure they are counted in your storage quotas view.

Method 1: Verify License Assignment in the Admin Center

1. Open the Microsoft 365 admin center
   Go to https://admin.microsoft.com and sign in with your admin credentials.
2. Navigate to Active Users
   Select Users > Active users from the left navigation menu.
3. Search for the missing user
   Type the user name or email in the search box and click the user to open their details panel.
4. Check the Licenses and apps tab
   In the user details panel, select the Licenses and apps tab. Confirm that OneDrive for Business is listed with a green check mark. If not, assign a license that includes OneDrive for Business, such as Microsoft 365 E3 or Office 365 E1.

Method 2: Provision a OneDrive Site for Licensed Users

1. Connect to SharePoint Online PowerShell
   Open Windows PowerShell as an administrator and run the following command to install the module if needed:
   Install-Module -Name Microsoft.Online.SharePoint.PowerShell
   Then connect to your tenant:
   Connect-SPOService -Url https://yourtenant-admin.sharepoint.com
2. Run the provisioning cmdlet for a single user
   Execute:
   Request-SPOPersonalSite -UserPrincipalName user@yourtenant.com
   Replace the email address with the missing user. This cmdlet creates the OneDrive site immediately.
3. Provision multiple users at once
   To provision several users, create a CSV file with a column named UserPrincipalName and run:
   $users = Import-Csv -Path C:\users.csv
Request-SPOPersonalSite -UserPrincipalName $users.UserPrincipalName
4. Verify site creation
   Run Get-SPOSite -IncludePersonalSite $true -Filter "Url -like '-my.sharepoint.com/personal/'" and look for the user’s URL in the output. The site should appear immediately after provisioning.

Method 3: Use Microsoft Graph API to Retrieve Storage Data

1. Register an app in Azure AD
   Go to https://portal.azure.com, select Azure Active Directory > App registrations > New registration. Enter a name and click Register.
2. Grant API permissions
   In the app settings, select API permissions > Add a permission > Microsoft Graph > Application permissions. Add Reports.Read.All. Click Grant admin consent.
3. Get an access token
   Use a tool like Postman or a PowerShell script to request a token for the https://graph.microsoft.com resource. Include your tenant ID, client ID, and client secret.
4. Call the OneDrive usage report endpoint
   Send a GET request to:
   https://graph.microsoft.com/v1.0/reports/getOneDriveUsageAccountDetail(period='D7')
   Replace D7 with D30 or D90 for longer periods. The response contains a CSV file with columns for UserPrincipalName, StorageUsed, and StorageAllocated. Users without a site will show zero storage used but will still appear in the report if they are licensed.

If Users Still Do Not Appear After the Main Fix

OneDrive Storage Quotas Report Shows Zero Users

If the entire report is empty, check that the reporting service is enabled. Go to Microsoft 365 admin center > Reports > Usage and verify that OneDrive reports are enabled under Settings > Reports. If reports are disabled, enable them and wait 48 hours for data to populate.

User Has a Site But No Storage Quota Appears

This occurs when the site was created by a third-party tool or migration script that bypassed the standard provisioning process. Use Get-SPOSite -Identity to check the StorageQuota property. If it shows a default value like 0 or 1024, set a quota manually with Set-SPOSite -Identity -StorageQuota 10485760 for 10 GB.

User Is Licensed but Site Never Provisioned

Some organizations block automatic OneDrive site creation via the SharePoint admin center. Go to SharePoint admin center > Policies > Sharing and check if Allow users to create personal sites is set to Off. If so, turn it on and then provision sites using the PowerShell cmdlet from Method 2.

Admin Center Report vs PowerShell vs Graph API: Key Differences

Item	Admin Center Report	SharePoint Online PowerShell	Microsoft Graph API
Data freshness	24–48 hours delayed	Real-time	24–48 hours delayed
Shows unlicensed users	No	Yes, if site exists	Yes, if licensed
Shows users without a site	No	No	Yes, with zero storage
Requires admin role	Reports reader	SharePoint admin	Reports reader
Can set quota	No	Yes	No

You can now identify and resolve missing users in the OneDrive storage quotas report by checking license assignments, provisioning sites, or using the Graph API to collect data for all licensed users. Next, review the storage quota limits for each user and adjust them with the Set-SPOSite -StorageQuota cmdlet to prevent oversubscription. For tenants with more than 10,000 users, schedule a weekly PowerShell script that exports storage data to a CSV file for offline analysis.