cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kat12345
Helper III
Helper III

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

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 

 

 

 

 

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

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.

View solution in original post

5 REPLIES 5

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
Community Support
Community Support

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.

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

Thank you very much!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!