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
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
Highlighted
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
Highlighted

@Christopher Hoard  Thanks I will check that out!

Highlighted
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