Customize the reports in Microsoft 365 usage analytics
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 Activation tab within the Activation/Licensing report.
Within the Activation/Licensing report, click on the Activation tab.
Enter the edit mode by clicking the Edit button on the top through the button.
On the top right, click Duplicate this page.
In the bottom right, click on any of the bar charts showing the count of users activating based on the OS such as Android, iOS, Mac, etc.
In the Visualizations area to the right, in order to remove Mac Count from the visual, click on the X next to it.
Create a new visual
The following example shows how to create a new visual to track new Yammer users on monthly basis.
Go to the Product Usage report using the left nav and click on Yammer tab.
Switch to edit mode by clicking on and Edit.
At the bottom of the page, click on to create a new page.
In the Visualizations area to the right, click the Stacked bar chart (top row, first 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.
In the Fields area to the right, expand the TenantProductUsage table.
Drag FirstTimeUsers to the fields area, directly below the Value heading.
Drag Product to the Filters area, directly below the Visual level filters heading.
In the Filter Type area that appears, select the Yammer check box.
Just below the list of visualizations, click the Format icon .
Expand Title and change the Title Text value to First-Time Yammer Users by Month.
Change the Text Size value to 12.
Change the title of the new page by editing the name of the page on bottom right.
Save out the report by Clicking on Reading View on top and then Save.
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.
Enter your Office 365 (organization or school) admin credentials to authenticate to Office 365 when prompted.
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:
Open the pbit file.
Enter your tenant id value in the dialog.
Enter your admin credentials to authenticate to Office 365 when prompted.
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.