In this article

Customize the reports in Microsoft 365 usage analytics

In this article

Microsoft 365 usage analytics provides a dashboard in Power BI that offers insights into how users adopt and use Office 365. The dashboard is just a starting point to interact with the usage data. The reports can be customized for more personalized insights.

You can also use the Power BI desktop to further customize your reports by connecting them to other data sources to gain richer insights about your business.

Customizing reports in the browser

The following two examples show how to modify an existing visual and how to create a new visual.

Modify an existing visual

This example shows how to modify the Adoption overview report.

At the top of the dashboard, in the Understanding adoption area, point to the Adoption overview card, and then click it.

In the top navigation, click Edit report.

At the top right, click Duplicate this page.

At the top right of the report, click the title bar of the Adoption overview graph.

In the Visualizations area to the right, for the FirstTimeUsers column, click the X to the right to remove it.

At the top right of the Adoption overview visual, click the Pin visual icon and in the dialog, click Pin > Existing dashboard.

At the top of the browser, in the breadcrumb, click the Office 365 Adoption link to return to the dashboard.

If prompted to save changes to the report, click Don't save.

Scroll to the bottom of the dashboard to locate the visual you just saved.

Drag it to the top of the dashboard.

You can optionally delete the original Adoption overview card, by clicking the ellipsis on the top right of the card, and then choosing Delete.

Create a new visual

The following example shows how to create a new visual to track new Yammer users on monthly basis.

In the Communication area of the dashboard, click the Yammer - Any Active Users card and in the top navigation click Edit report.

At the bottom, click the new page icon to create a new page.

In the Visualizations area to the right, click the Stacked column chart (top row, second from left).

Click the bottom right of that visualization and drag to make it larger.

In the Fields area to the right, expand the Calendar table.

Drag MonthName to the fields area, directly below the Axis heading in the Visualizations area.

Expand Title and change the Title Text value to First-Time Yammer Users by Month.

Change the Text Size value to 12.

At the top right of the visual, click the Pin visual icon and in the dialog, click Pin > Existing dashboard.

At the top of the browser, in the breadcrumb, click the Office 365 Adoption link to return to the dashboard.

Scroll to the bottom of the dashboard to locate the visual you just saved.

Customizing the reports in Power BI Desktop

For most customers modifying the reports and chart visuals in Power BI web will be sufficient. For some however, there may be a need to join this data with other data sources to gain richer insights contextual to their own business, in which case they can customize and build additional reports using Power BI Desktop. You can download Power BI Desktop for free.

Use the reporting APIs

You can start by connecting directly to the ODATA reporting APIs from Office 365 that power these reports.

Go to get data > Other > ODATA Feed > Connect.

In the URL window enter "https://reports.office.com/pbi/v1.0/<tenantid>"

Note

The reporting APIs are in preview and are subject to change until they go into production.

See the FAQ for more information about who is allowed to access the Office 365 Adoption content pack reports.

Once the connection is authorized, you will see the Navigator window that shows the datasets available to connect to.

Select all and click on Load.

This will download the data into your Power BI Desktop. Save this file and then you can start creating the reports you need.

Use the Microsoft 365 usage analytics template

You can also use the Power BI template file that corresponds to the Microsoft 365 usage analytics reports as a starting point to connect to the data. The advantage of using the pbit file is that it has the connection string already established. You can also take advantage of all the custom measures that are created, on top of the data that the base schema returns and build on it further.

You can download the Power BI template file from the Microsoft download center from the Download center. After you have downloaded the Power BI template file follow these steps to get started:

for more information about who is allowed to access the Microsoft 365 usage analytics reports.

Once authorized, the data will be refreshed in the Power BI file.

Data load may take some time, once complete, you can save the file as a .pbix file and continue to customize the reports or bring an additional data source into this report.

Follow Getting started with Power BI documentation to understand how to build reports, publish them to the Power BI service, and share with your organization. Following this path for customization and sharing may require additional Power BI licenses. See Power BI licensing guidance for details.

Feedback

We'd love to hear your thoughts. Choose the type you'd like to provide: