Office 365 Adoption content pack

Note: This is pre-release documentation for a public preview, and is subject to change in future releases.

The Adoption content pack is now also available for Office 365 US Government Community.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Overview of the Office 365 Adoption content pack

Use the Office 365 Adoption content pack within Power BI to gain insights on how your organization is adopting the various services within Office 365 to communicate and collaborate. You can visualize and analyze Office 365 usage data, create custom reports and share the insights within your organization and gain insights into how specific regions or departments are utilizing Office 365.

The content pack gives you access to a pre-built dashboard that provides a cross-product view of the last 12 months an  contains a number of sections. Each section provides you with specific usage insights. By clicking on the top level metrics you can access more detailed reports. User specific information is available for the last month.

See Enable the Power BI adoption content pack for Office 365 to start collecting data.

A screen shot of the list of  reports included in the adoption content pack

The dashboard contains a number of reports, including:

  • Adoption — offers an all-up summary of adoption trends. Use the reports in this section to learn how your users have adopted Office 365as well as how usage of the individual services has changed month-over-month. You can see how many licenses are assigned, how many of those are in active use by people in your organization, how many users are returning users and how many are using the product for the first time.

  • Storage use report — Use this report to track cloud storage for mailboxes, OneDrive and SharePoint sites. You can use this to make sure people in your organization stay within limits, or to decide if you need to purchase more storage resources.

    To view Exchange Online storage information, click into the report.

  • Communication report — You can see at a glance whether people in your organization prefer to stay in touch by using Yammer, email, or Skype calls. You can observe if there are shifts in patterns of use of communication tools amongst your employees 

  • Collaboration report — See how people in your organization use OneDrive and SharePoint to store documents and collaborate with each other, and how these trends evolve month over month. You can also see how many people share documents internally or externally and how many SharePoint sites or OneDrives accounts are actively being used.

  • Activation report — Track Office 365 ProPlus, Project and Visio activations in your organization. Each person with an Office license can install products on up to five devices. Use reports in this section to see the device types on which people have installed Office apps.

  • Access from anywhere report — Track which clients and devices people use to connect to email, Skype for Business, or Yammer.

  • The content pack combines your users usage date with the information of your users in Active Directory. Thus, in many reports, you can pivot by the following Active Directory attributes: location, department and organization.

You can access detailed reports for each area by clicking on the data tables. You can view all pre-built reports by clicking on the tabs at the bottom of the site, once you are viewing the reports. For more detailed instructions ,read Working with the reports in the adoption content pack and Customize the Office 365 Adoption Content Pack.

FAQ

Question

Answer

Is this content pack going to be available through purchase or will it be made available for free?

The content pack is available to all customers free of charge. You need to sign up for the free Power BI service to connect to the content pack. You can also customize the dashboards and reports with the free Power BI service.

To share the dashboards with others both the user who is sharing and the user the dashboard is shared with must have PowerBI Pro.

Who can connect to the Office 365 Adoption content pack?

You have to be either a global administrator, Exchange administrator, Skype for Business administrator, or SharePoint administrator in order to connect to the content pack. See Office 365 admin roles for more information.

A new role that would allow a user to read reports is also under consideration.

Who can customize the dashboards and reports in the Office 365 Adoption content pack?

Only the user who made the initial connection to the content pack can customize the dashboard or create new reports in the Power BI web interface. See Customize the Office 365 Adoption Content Pack for instructions.

Can I only customize the dashboards and reports in the Office 365 Adoption content pack from the Power BI web interface?

In addition to customizing the dashboard and reports from the Power BI web interface, users can also use Power BI desktop to connect directly to the Office 365 reporting service to build their own reports.

See Working with the reports in the Office 365 adoption content pack for more information.

How can I get the pbit file that this dashboard is associated with?

Users can access to the pbit file from the Microsoft Download center

Who can view the dashboards and reports in the Office 365 Adoption content pack?

The user who connected to the content pack can share the content pack with anybody by using the sharing functionality. Power BI licensing requires that both the user sharing and the user with whom a dashboard is shared have Power BI Pro or Power BI Premium.

Can anyone share the dashboard, or does it have to be the person who connected to the dashboard?

When sharing the dashboard, you can either allow users to re-share the dashboard with others or not. You can set this option at the time of sharing.

Is it possible to work on and customize the same content pack with a group of people?

Yes. To enable a group of admins to work together on the same content pack, you can leverage the app workspace functionality i Power BI, for more information, see How should I collaborate and share dashboards and reports?

For which timeframe is data available?

The majority of the reports display data for the previous 12 months. However, some of the charts may show less history since the data collection for different products and reports were started at different times and thus data for the full 12 months might not be available. All the reports will eventually build up to 12 months of history. Visuals that indicate Latest in the title show data up to current date. Visuals that indicate Last month in the title show data for the previous complete month. Reports that show user level details show data for the previous complete month.

What data is included in the content pack?

The data in the content pack covers the same set of activity metrics as is available in the Office 365 usage activity reports. The only missing data is for Office 365 groups activity (as of May 2017). As more reports are incrementally added to the Usage Activity reports this gap will increase since the content pack is a point in time release and cannot be updated without re-releasing a new content pack with additional data points.

How does the data in the content pack differ from the data in the usage reports in the admin center?

The data you see in the content pack matches the data you see in the activity reports in the Office 365 admin center. The key differences are that in the admin portal data is available for the last 7/30/90/180-days while the content pack presents data at a monthly boundary for up to 12 months. In addition, user level details in the content pack are only available for the last complete month for users who were assigned a product license and performed an activity. In the Office 365 admin center, user level information is available for the entire reporting period.

When should I use the content pack and when the usage reports in the admin center?

The Office 365 usage activity reports are a good starting point to understand usage and adoption of Office 365. The content pack combines the Office 365 usage data and your organization’s Active Directory information and enables admins to analyze the data set using the visual analytics capabilities of Power BI. This enables admins to not just visualize and analyze Office 365 usage data, but also slice it by Active Directory properties such as departments, location etc. They can also create custom reports and share the insights within their organization.

How often is the data refreshed?

When you connect to the content pack for the first time, it will automatically populate with your data for the previous 12 months. After that, the content pack will refresh weekly. Customers can choose to modify the refresh schedule if their use of this data demands a different update rhythm such as daily.

The back-end Office 365 service will refresh data on a daily basis and provides data that is between 36-72 hours latent from the current date.

The Content date column in each dataset represents the freshness date of the data in the content pack.

How do you define an active user?

The definition of active user is aligned to the definition of active user in the activity reports in the Office 365 admin center.

See active user definition for more information.

What SharePoint site collections are included in the SharePoint reports?

The current version of the content pack includes file activity from SharePoint team sites and SharePoint group sites.

When will an updated version of the content pack become available?

This is not yet determined.

Is it possible to integrate the data from the content pack into existing solutions?

The data in the content pack can be retrieved through the Office 365 APIs. These APIs are in public preview. When they ship to production they will be merged within the Microsoft Graph reporting APIs.

Are there any plans to expand the content pack to show usage data from other products within Office 365 (i.e. Planner, teams, bookings and other web-based Office 365 apps)

This is considered for future improvements. Check the Office 365 Roadmap for updates.

How can I pivot by company information in Active Directory?

Company information is included one of the Active Directory fields in the content pack and you can see it as a pre-built filter in the Product User activity reports. It is available as column in the UserState table.

Is it possible to bring in additional fields from Active Directory?

Additional customization on this data is possible by connecting to the Microsoft Graph reporting APIs to pull additional fields from Azure Active Directory and join to the Office 365 usage data source.

Is it possible to aggregate the information in the content pack across multiple Office 365 subscriptions?

At this time, the content pack is for a single subscription, as it is associated with the credentials that was used to initially connect to it.

Is it possible to see usage by SKU (i.e. E1, E3)

In the content pack, usage is represented at the per product level. Data about the various subscriptions that are assigned to users are provided, however it is not possible to correlate user activity to the subscription assigned to user.

Is it possible to integrate other data sets into the content pack?

You can use Power BI Desktop to connect to the Office 365 APIs (in preview) to bring additional data sources to combine with the content pack data.

Fore more information see the Customize document.

Is it possible to see the “Top Users” reports for a specific timeframe? i.e. previous month or previous week

All user level reports present aggregated data for the previous month.

Will the content pack be localized?

This is currently not on the roadmap.

I have a specific question about the data I’m seeing for my organization. Who can I reach out to?

You can use the feedback button in the Office 365 Admin center activity overview page, or you can open a support case to get help with the content pack.

How can partners access the data?

If a partner has delegated admin rights, he or she can connect to the content pack on behalf of their customer.

Can I hide identifiable information such as user, group, and site names in reports?

Yes, see Make the collected data anonymous.

Related Topics

Enable the Power BI adoption content pack for Office 365
Working with the reports in the Office 365 adoption content pack
Active user in Office 365 usage reports
Troubleshoot Office 365 Adoption Content Pack
Adoption content pack data model
Customize the Office 365 Adoption Content Pack

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×