Getting Started with Office 365 Adoption Content Pack in Power BI

In May 2017, Microsoft announced the availability of Office 365 Adoption Content Pack in Power BI public preview. The Office 365 Adoption Content Pack allows more visibility in to the usage and adoption of Office 365 service in a tenant. This is very important when it comes to business decision makers to understand if the investment on the cloud platform was worth. While Office 365 does include various usage reports in the admin center, this is a different way of representing the usage in your organization. I wouldn’t go in to explain the differences between the adoption content pack and built-in usage reports as that is not this post is about. You will be able to see what are those by yourself if you followed following steps to enable the adoption content pack and view the dashboard in Power BI.

  1. Go to Reports -> Usage and find the Office 365 Adoption (Preview) tile.

    Enable from Usage Reports

    Enable from Usage Reports

  2. Click on Get started, and then slide the switch to On.

    Switch On

    Switch On

  3. Once enabled, you can close the page.

    Enabled

    Enabled

  4. Depending on the size of your tenant, it can take 24-48 hours before the data become available for the adoption content pack.

    Preparing Data

    Preparing Data

  5. Once data is ready, you can click on Go to Power BI button or directly sign in to Power BI portal to start the data import process. Make a note of the tenant ID that is in this tile.

    Go to Power BI

    Go to Power BI

  6. In the Power BI portal, from the Microsoft AppSource, click on Get in the Services tile.

    Services in Power BI

    Services in Power BI

  7. Scroll until you find Office 365 Adoption Preview.

    Office 365 Adoption Preview App

    Office 365 Adoption Preview App

  8. Enter the tenant ID found in the Office 365 admin center.

    Tenant ID

    Tenant ID

  9. In the next scree, you need to sign in to your Office 365 tenant.

    Authentication method

    Authentication method

  10. Once completed, Power BI will start importing data that was ready by Office 365.

    Importing Data

    Importing Data

  11. Once the data is imported, you can use the dashboard to see various chats, graphs, statistics and other analytical data related to your users’ Office 365 adoption.

    Your dataset is ready

    Your dataset is ready

Play around the dashboard and if you want, you can write custom queries to get specific reports as well.

Leave a Reply