Microsoft 365 Usage Analytics Report Not Loading User Activity Data Despite Successful Refresh and Admin Permissions.

Based on the documented Microsoft 365 Usage Analytics troubleshooting guidance, the most relevant checks are these:

1. Confirm the tenant is subscribed to Usage Analytics data
   • In the Microsoft 365 admin center, go to Show all → Reports → Usage.
   • In Microsoft 365 usage analytics, select Get Started.
   • Make sure Make organizational usage data available to Microsoft 365 usage analytics for Power BI is selected, then select Save.
   • After enabling this, data preparation can take up to 24 hours, and in some cases 2 hours to 48 hours. The guidance also states the data should appear within three days.
2. Verify the tenant is no longer in data-preparation state
   • If the Usage page shows We are processing your data, or Power BI returns error 423 stating data is still being prepared, this means historical usage data is still being generated.
   • If the status does not change to Your data is ready after three days, the documented action is to contact Microsoft 365 for business support.
3. Verify the account used to connect the template app has a supported role
   • Supported roles for accessing this data include:
     • Exchange Administrator
     • Skype for Business Administrator
     • SharePoint Administrator
     • Global Reader
     • Reports Reader
   • Microsoft recommends using the least-privileged role needed rather than relying on Global Administrator.
   • The context specifically identifies Reports Reader as a role that can view usage data and activity reports in the Microsoft 365 admin center and view data returned by Microsoft Graph reporting API.
4. If refresh succeeds but the dataset still does not populate, re-enter dataset credentials
   • In Power BI, locate the dataset for the Microsoft 365 Usage Analytics template app.
   • Select schedule refresh.
   • Re-enter the admin credentials.
   • If that does not resolve it, clear the cache and re-create the template app.
5. If user names are hidden or appear anonymous, check the privacy setting
   • In the Microsoft 365 admin center, go to Settings → Org Settings → Services → Reports.
   • Clear the concealment option for report identities, such as Conceal user, group, and site names in all reports or Display concealed user, group, and site names in all reports, depending on the admin center wording.
   • This setting requires Global Administrator.
   • This setting affects whether user identities are shown in reports; it does not by itself create missing activity data.

What the documented guidance supports for the specific questions:

• Additional tenant settings or roles required:
  • The key tenant setting is enabling organizational usage data for Power BI from Reports → Usage.
  • The documented supported roles are the ones listed above, especially Reports Reader for reporting access.
• Known issue with successful refresh but missing data:
  • The documented causes are:
    • the tenant has not been subscribed to usage analytics data,
    • the tenant data is still being prepared,
    • credentials used by the dataset need to be re-entered.
• App retirement / API changes / recommended replacement:
  • No supported answer is available from the provided material.
• How to verify whether the issue is source data, tenant config, permissions, or report:
  • Use this sequence:
    1. In Microsoft 365 admin center → Reports → Usage, verify the tenant was enabled with Make organizational usage data available to Microsoft 365 usage analytics for Power BI.
    2. On the same page, verify the status is not still We are processing your data.
    3. Confirm the account used for the template app has one of the supported reporting roles, preferably Reports Reader or another listed role.
    4. In Power BI, re-enter credentials under the dataset schedule refresh settings.
    5. If identities are hidden rather than absent, review the Reports privacy setting for concealed names.
    6. If the tenant still does not show Your data is ready after three days, contact Microsoft 365 support.

One important note on the app registration details already tried: the provided material does not state that extra Microsoft Graph permissions such as Calendars.Read.All are required for the Microsoft 365 Usage Analytics template app. The documented access requirements focus on the Microsoft 365 reporting roles and the tenant-level Usage Analytics enablement.

References:

• Troubleshoot Microsoft 365 usage analytics
• About administrator roles in the Microsoft 365 admin center
• Microsoft 365 reports show anonymous user names instead of actual user names