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

Question

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

Kartik Kumar 0

Screenshot 2026-10-15 214847.pngHello Microsoft Community,

I am facing an issue with the Microsoft 365 Usage Analytics report in Power BI. The report loads successfully, and the scheduled refresh completes with a successful status, but the user activity data is not loading or appearing inside the report.

I have already tried the following troubleshooting steps:

1. Power BI and Microsoft 365 Admin Center settings

Navigated to Microsoft 365 Admin Center → Settings → Org settings → Reports.

Enabled the option to allow access to Power BI content in usage reports.

Verified the relevant reporting settings in the Microsoft 365 Admin Center.

2. Microsoft Entra ID (Azure AD) app registration

Registered an application in Microsoft Entra ID to access Microsoft 365 reporting data.

Configured the required Microsoft Graph API permissions, including Reports.Read.All, Calendars.Read.All, and other relevant permissions.

Granted the necessary admin consent for the configured permissions.

3. Administrator roles I have assigned the relevant administrative roles to my account in the Microsoft 365 Admin Center, including Global Administrator, Global Reader, Exchange Administrator, Fabric Administrator, Usage Summary Reports Reader, and other roles, as shown in the attached screenshot.

4. Refresh status

The scheduled refresh runs successfully.

The refresh history shows a completed/successful status.

However, the report still does not display the expected user-level email and calendar activity data.

Expected result

The Microsoft 365 Usage Analytics report should load user-level activity data, including email activity (sent, received, and read counts) and calendar activity (meetings created and interacted with), for users in my organization.

Actual result

The refresh completes successfully, but the report does not display the expected usage activity data.

Questions

Are there any additional Microsoft 365 tenant settings, permissions, or administrative roles required to populate user-level activity data in the report?

Is there a known issue with the Microsoft 365 Usage Analytics Power BI content pack or its underlying reporting APIs?

Could this issue be related to the retirement of the Microsoft 365 Usage Analytics app in August 2026, or changes to the supported reporting APIs?

How can I verify whether the issue is caused by missing source data, tenant-level reporting configuration, API permissions, or the report itself?

What is the recommended Microsoft-supported approach for retrieving organization-wide email and calendar usage analytics now?

I would appreciate a step-by-step solution or guidance from anyone who has successfully configured this report recently.

Thank you!

0 comments

2 answers

Your answer

Answer 1

Kristen Tran 2,445 Independent Advisor

Hi Kartik,

Thank you for reaching out to the Microsoft Community and for sharing your detailed troubleshooting steps along with the screenshot. Your description of the empty User Activity page, including the Exchange User Detail table and the Top Ten Companies and Departments sections, despite a successful refresh and the correct admin roles, has been very helpful in reviewing your case.

This behavior occurs because the Microsoft 365 Usage Analytics Power BI template app reached its end of support on August 1, 2026, and as a result, it no longer reliably displays user-level activity data even when the refresh completes successfully. Microsoft 365 reports show anonymous instead of actual user names - Microsoft 365 | Microsoft Learn

Please follow the steps below that suit for your situation:

1/ Display real user names in usage reports

First, sign in to the Microsoft 365 admin center with a Global Administrator account.
Next, go to Settings, then Org settings, then Services, and select Reports.
After that, clear the option Display concealed user, group, and site names in all reports and select Save.
Please allow 24 to 72 hours for this change to take effect across all reports.
Reference: Microsoft 365 Admin Center Usage Reports Overview - Microsoft 365 admin | Microsoft Learn

2/ Verify that the source data is available

Then, in the admin center, go to Reports, then Usage, and open the Email activity report under Exchange.
If user details appear in this report, your tenant data is healthy, which confirms that the gap comes only from the retired Power BI app.

3/ Move to a supported reporting option

For regular monitoring, we recommend using the usage reports in the Microsoft 365 admin center, which you can export to Excel whenever needed.
Alternatively, if you prefer a Power BI dashboard, you can build a custom report based on the Microsoft Graph reports API using your registered app. In this case, only the Reports.Read.All permissions require admin consent.
Reference: Working with Microsoft 365 usage reports in Microsoft Graph - Microsoft Graph v1.0 | Microsoft Learn

Additionally, please note that usage data usually has a delay of about 48 hours, so the most recent activity may not appear immediately.

I hope this information is helpful. If you have any further questions, please don’t hesitate to reply. I’ll be glad to assist you further.

Best regards,

Kartik Kumar 0 Reputation points

2026-10-16T05:10:26.9266667+00:00

Hi @Kristen Tran , this is very helpful! I just want to clarify one thing: as you mentioned, Microsoft 365 Usage Analytics was retired after August 1, 2026. Does this mean the Power BI app is no longer usable now?

Also, when I open the Summary report, no data is displayed, even though I’ve enabled the required permissions. The individual tabs, such as Exchange, show data, but the Summary report remains empty. Could you please help clarify why this is happening?Screenshot 2026-10-16 111016.png
Kristen Tran 2,445 Reputation points Independent Advisor

2026-10-16T09:28:46.26+00:00
Hi Kartik,

Thank you for the clarification and for sharing the additional screenshot.

I'd like to clarify my previous comments regarding the Microsoft 365 Usage Analytics Power BI template app. Microsoft initially announced that the app would reach end of support on August 1, 2026. However, Microsoft later updated the related Message Center communication and advised customers to disregard the announcement while additional information is being prepared. As a result, I can't conclusively say that the Power BI template app is no longer usable based solely on the original retirement notice. The current Microsoft documentation still includes guidance for enabling and using the app.

Reference: Enable Microsoft 365 usage analytics - Microsoft 365 admin

Regarding your screenshot, the page shown is the Overview page in the Microsoft 365 admin center Usage reports, rather than the Summary page within the Power BI Usage Analytics app. Since reports for individual workloads, such as Exchange, are displaying data correctly, this suggests that the required permissions are in place and that usage data is being collected for the tenant.

The Overview page relies on aggregated data from multiple Microsoft 365 services. In some cases, the page may remain blank if the aggregated reporting data has not yet been fully generated or synchronized, even though data is already available in the individual workload reports. Additionally, usage reporting data typically becomes available within 24 to 72 hours, although it can occasionally take longer, and some reporting periods may not yet contain sufficient data.

As a next step, please try the following troubleshooting actions:

Change the reporting period from Past 180 days to Past 30 days or Past 7 days and check whether any data appears.

Allow up to 72 hours if usage reporting was recently enabled or if permissions were recently updated.

Test the page in an InPrivate/Incognito browser session to rule out any cached portal data.

If the Overview page continues to show no data while multiple individual reports display information successfully, please consider opening a support request through Support > Help & support in the Microsoft 365 admin center. The support team can investigate the tenant's reporting backend, which is beyond the scope of what can be reviewed through the community forum.

In the meantime, you can continue using the individual service reports, as the data shown there indicates that the underlying service-level reporting is functioning correctly.

Should you have any questions or updates, please feel free to let me know. I'll be happy to assist further.

Best regards,

Answer 2

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

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.
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.
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.
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.
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: