Office
Sign in

Enable Microsoft 365 usage analytics

Microsoft 365 usage analytics is also available for Office 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 Office 365 admin center, then instantiate the content pack in Power BI.

Get Power BI

If you don't already have Power BI, you can sign up for the free Power BI service. Choose Get started free to get the free version.

Choose Get started free to get Power Bi

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

Enable the content pack

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

See Office 365 admin roles for more information.

  1. Sign in with your admin credentials, and go to the Admin center.

  2. In the admin center, expand the left nav, and go to Reports > Usage.

  3. On the Usage page, locate the Microsoft 365 usage analytics card, and choose Get started.

  4. On the Reports panel that opens, set Make data available the 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.

Instantiate the content pack

To instantiate the content pack, 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 choose Go to Power BI.

  2. When you get to Power BI, sign in. Choose Get Data, then under More ways to create your own content choose Service Content Packs.

    Under Content Pack Library, in Services, choose Get.
  3. In the Apps tab, type Microsoft 365 in the search box and then select Microsoft 365 usage analytics > Get it now.

  4. On the Connect to Microsoft 365 usage analytics screen, type in the tenant Id you copied in step (1) > Next.

  5. On the next screen, choose oAuth2 as the Authentication method > Sign in. If you choose any other authentication method, the connection to the content pack will fail.

    Choose oAuth2 as authentication method
  6. Once the content pack 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 the following reports - which will show tiles without data - until that point:

    See Navigating and utilizing the reports in Microsoft 365 usage analytics for tips on how to view and use these reports.

    • Exchange – User activity

    • Skype for Business - User activity

    • Teams - User activity

    • Yammer - User activity

    • OneDrive - User activity

    • SharePoint - User activity

    • Adoption by department

    • Adoption by product

    • Adoption by region

    • Yammer usage

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 content pack .

  1. In the admin center, expand the left nav, and go to Settings > Services & add-ins.

  2. On the Services & add-ins page choose Reports, and then turn on the toggle next to Display anonymous identifiers instead of names in all reports.This setting gets applied both to the usage reports as well as to the content pack.

    Set toggle to on to make reports anonymous
  3. Choose Save.

Related Topics

Microsoft 365 usage analytics
Active user in Office 365 usage reports
Navigating and utilizing the reports in Microsoft 365 usage analytics
Customizing the reports in Microsoft 365 usage analytics
Troubleshooting Microsoft 365 usage analytics
Microsoft 365 usage analytics data model

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×