Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

V-pazhen-msft

How to get access to Microsoft 365 usage analytics to develop a custom report in Power BI Desktop?

 

Here are three methods:

First. Connect the data directly in Power BI Desktop using the reporting APIs 

Second. Use the Microsoft 365 usage analytics template 

Third. Connect Power BI dataset in Power BI Desktop 

 

The specific steps of the first two methods can be viewed in the official doc: Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Docs.

 

And here are some tips for the first two methods:

 

  1. For the first method, Tenant ID is needed. Then, how should you to get it?

 

Go to Power BI Service > Ellipsis (next to the avatar) > Help and Support >About Power BI

 

You can see Tenant URL and Tenant ID is the part after 'ctid'. Then you can copy and paste it into Power BI Desktop to use.

Vpazhenmsft_0-1635923320498.png

 

  1. If there is a connection error like below, it may be a permission cache problem, you can clear it and edit the credentials again.

Vpazhenmsft_1-1635923320502.png

 

Vpazhenmsft_2-1635923320505.png

 

Vpazhenmsft_3-1635923320506.png

 

Now let’s introduce the third method - Connect Power BI dataset in Power BI Desktop.

 

Here are the detailed steps:

 

  1. Go to Power BI Service > Select Apps > Select Microsoft 365 usage in the search box and click 'Get it now'.

Vpazhenmsft_4-1635923320508.png

 

 

  1. Once the app is installed, we can open the dashboard and click 'connect your date', and then enter your tenant ID.

Vpazhenmsft_5-1635923320510.png

 

Vpazhenmsft_6-1635923320513.png

 

  1. Then, select OAuth2 as the Authentication method > Sign in.

If you choose any other authentication method, the connection to the template app will fail.

 

  1. When the template 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 minutes to 30 minutes.

 

  1. Update the app and add the build permission to specific users or group.

Vpazhenmsft_7-1635923320516.png

 

  1. Go to Power BI Desktop > Connect to Power BI datasets > Choose Microsoft 365 Usage Analytics

Vpazhenmsft_8-1635923320519.png

 

  1. You can get all data model and customize your report by yourself.

 

Using this method allows multiple users to customize the report in Power BI Desktop, and the entire data model (including measures) of the template app can be used.

 

Note: You may need the administrator to enable the following functions to get and refresh the data.

Go to admin center>Setting>Org setting>Service>Reports>Set two buttons to On > Save.

Vpazhenmsft_11-1635923438287.png

 

Each of the three methods has advantages and disadvantages, choose the most suitable one according to your needs.

 

 

Author: Janey Guo

Reviewer: Ula Huang, Kerry Wang

Comments