how to build M365 usage reports with our Office 365 data?

[Anonymous]

Hi All,

I am progressing on the use of Power Bi Desktop. 

So I would like to create the M365 usage reports with the data from our tenant. What "get data source" do you pick up?

or is there any other process?

thanks 

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/enable-usage-analytics?view=o365-worldwide

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/usage-analytics?view=o365-worldwide

https://www.youtube.com/watch?v=Qyxf7dPWlUc

https://www.youtube.com/watch?v=lC3JXLQsKMY

[Anonymous]

thanks Amitchandak for your quick reply

but this is not what i am looking for.

I have my reports in Power Bi service. But i would like to rework the visuals on Power bi desktop.

In power bi service, open the Teams user activity report and tried to download the .pbix file, but I cannot because it is greyed out (disabled).

I don't work on power bi service, because we cannot do all transformation and i would like to do not make any mistakes on Microsoft's usage reports.

thanks for your help again

[v-xicai · Accepted solution]

Hello @Kat12345 ,

You can download the Microsoft 365 Power BI Usage Analytics template file from the Microsoft Download Center from the Download Center. After you download the Power BI template file, follow these steps to get started:

1.Open the pbit file.

2.Enter the value of your tenant ID in the dialog box.

3.Enter your administrator credentials to authenticate to Microsoft 365 when prompted.

For reference:

Customize reports in Microsoft 365 usage analysis

Best regards

Amy

Community Support Team _ Amy

If this post helps,then consider Accepting it as the solution to help other members find it more quickly.

[kathysham]

The download link downloads a ZIP file - there is not a pbix file in the ZIP. So I am missing the connection between the file I download and the pbix file. Is there something I need to do to convert this to a pbix?
Thanks!

-kathy

[Anonymous]

Thank you very much!