Enable Microsoft 365 usage analytics

Note

The admin center is changing. If your experience doesn't match the details presented here, see About the new Microsoft 365 admin center.

Microsoft 365 usage analytics is also available for Microsoft 365 US Government Community.

Steps to enable Microsoft 365 usage analytics

To get started with Microsoft 365 usage analytics you must first make the data available in the Microsoft 365 admin center, then initiate the template app in Power BI.

Get Power BI

If you don't already have Power BI, you can sign up for Power BI Pro. Select Try free to sign up for a trial, or Buy now to get Power BI Pro.

You can also expand Products to buy a version of Power BI.

Note

You need a Power BI Pro license to install, customize, and distribute a template app. For more information, please see Prerequisites.

You need a Power BI Pro license to share your content, and the people you share it with do too, or the content needs to be in a workspace in a Premium capacity.

Enable the template app

To enable the template app, you have to be either a global administrator, report reader, Exchange administrator, Skype for Business administrator, or SharePoint administrator.

See About admin roles for more information.

  1. In the admin center, go to the Reports > Usage page.

  2. On the Usage page, locate the Microsoft 365 usage analytics card, and select Get started.

  3. On the Reports panel that opens, set Make data available to Microsoft 365 usage analytics for Power BI to On > Save.

This initiates the data collection process and will complete in 2 to 48 hours depending on the size of your tenant. The Go to Power BI button will be enabled (no longer gray) when data collection is complete.

Initiate the template app

To initiate the template app, you have to be either a global administrator, report reader, Exchange administrator, Skype for Business administrator, or SharePoint administrator.

  1. Copy the tenant Id and select Go to Power BI.

  2. When you get to Power BI, sign in. Select Apps->Get apps from the navigation menu.

  3. In the Apps tab, type Microsoft 365 in the search box and then select Microsoft 365 usage analytics > Get it now.

    Select Get it now

  4. Once the app is installed. Click on the tile to open it.

  5. Click Explore app to view the app with sample data. Click Connect to connect the app to your organization’s data.

  6. After clicking Connect, on the Connect to Microsoft 365 usage analytics screen, type in the tenant Id (without dashes) you copied in step (1), and select Next.

  7. On the next screen, select oAuth2 as the Authentication method > Sign in. If you choose any other authentication method, the connection to the template app will fail.

    Choose oAuth2 as authentication method

  8. Once the template app is instantiated the Microsoft 365 usage analytics dashboard will be available in Power BI on the web. The initial loading of the dashboard will take between 2 to 30 minutes.

Tenant level aggregates will be available in all reports. User-level details will only become available after the 1st or 15th day of the calendar month after opting in. This will impact all reports under User Activity (See Navigate and utilize the reports in Microsoft 365 usage analytics for tips on how to view and use these reports).

Make the collected data anonymous

To make the data that is collected for all reports anonymous, you have to be a global administrator. This will hide identifiable information such as user, group and site names in reports and in the template app .

  1. In the admin center, go to the Settings > Org Settings, and under Services tab, choose Reports.

  2. Select Reports, and then choose to Display anonymous identifiers. This setting gets applied both to the usage reports as well as to the template app.

  3. Select Save changes.