Enable Microsoft 365 usage analytics

Microsoft 365 usage analytics is not yet 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.

To share your data, both you and the people who you share the data with, need a Power BI Pro license, or the content needs to be in a workspace in a Power BI premium service.

Enable the template app

To enable the template app, you have to be a Global administrator.

See about admin roles for more information.

  1. In the admin center, go to the Settings > Org settings > Services tab.

  2. On the Services tab, select Reports.

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

The data collection process will complete in two 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.

Start the template app

To start 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. Then 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. Select the tile to open it.

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

  6. Choose Connect, on the Connect to Microsoft 365 usage analytics screen, then 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 Microsoft account as authentication method

  8. After 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 after opting in. User-level details will only become available around the 5th of the next 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.