Home

Reporting and PowerBI

%3CLINGO-SUB%20id%3D%22lingo-sub-564150%22%20slang%3D%22en-US%22%3EReporting%20and%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564150%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20better%20preparation%20and%20visualization%20I%20would%20like%20to%20import%20the%20teams%20reports%20%5Busage%20report%2C%20user%20activity%20report%2C%20device%20usage%20report%5D%20into%20PowerBI.%20Has%20anyone%20solved%20this%20problem%20yet%20or%20is%20there%20a%20PowerBI%20Content%20Pack%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20aware%20that%20the%20data%20is%20available%20via%20graph.%20Before%20I%20invest%20time%20I%20wanted%20to%20check%20if%20someone%20has%20already%20done%20this%2C%20couldn't%20find%20anything%20on%20Google.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAlex%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-564150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564169%22%20slang%3D%22en-US%22%3ERe%3A%20Reporting%20and%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564169%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EWhy%20not%20try%20the%20Microsoft%20365%20content%20pack%20which%20contains%20the%20Teams%20usage%20reports%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fadmin%2Fusage-analytics%2Fusage-analytics%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fadmin%2Fusage-analytics%2Fusage-analytics%3Fview%3Do365-worldwide%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EMight%20try%20this%20before%20the%20Graph!%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20helps!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564173%22%20slang%3D%22en-US%22%3ERe%3A%20Reporting%20and%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%20Thanks%20I%20will%20check%20that%20out!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Alexander Filipin
Occasional Contributor

Hi Everyone,

 

for better preparation and visualization I would like to import the teams reports [usage report, user activity report, device usage report] into PowerBI. Has anyone solved this problem yet or is there a PowerBI Content Pack?

 

I am aware that the data is available via graph. Before I invest time I wanted to check if someone has already done this, couldn't find anything on Google.

 

Thanks,

Alex

3 Replies
Hi!

Why not try the Microsoft 365 content pack which contains the Teams usage reports?

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

Might try this before the Graph!

Hope that helps!

Best, Chris

@Christopher Hoard  Thanks I will check that out!

Not sure if the data in the Content Pack and the data you see in the Teams reports in the Teams Admin Center is the same one. By the way, you can also try to use the Office 365 Reporting API exposed through the Graph
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies