Home

Power BI and Microsoft Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-123035%22%20slang%3D%22en-US%22%3EPower%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123035%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20look%20at%20reporting%20on%20data%20that%20is%20held%20within%20Microsoft%20Teams%20but%20it%20appears%20that%20there%20are%20no%20connectors%20for%20this%20with%20power%20BI%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20of%20achieving%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-123035%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159081%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159081%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3Ewhat%20data%20are%20you%20looking%20for%3F%3C%2FP%3E%0A%3CP%3EIf%20you%20alreaddy%20have%20the%20data%2C%20but%20want%20to%20push%20them%20to%20power%20bi%2C%20take%20a%20look%20at%20my%20blogpost%20on%20conencting%20PowerShell%20and%20powerbi.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Falexholmeset.blog%2F2018%2F02%2F11%2Foffice-365-groups-reporting-and-power-bi-visualisation%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Falexholmeset.blog%2F2018%2F02%2F11%2Foffice-365-groups-reporting-and-power-bi-visualisation%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123057%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123057%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20it%20out%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FOffice-365-Adoption-Content-Pack-77ff780d-ab19-4553-adea-09cb65ad0f1f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20Adoption%20content%20pack%3C%2FA%3E%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FEnable-the-Power-BI-adoption-content-pack-for-Office-365-9db96e9f-a622-4d5d-b134-09dcace55b6a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEnable%20the%20Power%20BI%20Adoption%20content%20pack%20for%20Office%20365%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPer%20above%2C%20it's%20being%20renamed%20to%26nbsp%3BOffice%20365%20Usage%20Analytics%20with%20support%20for%20Teams%20in%20the%20new%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20299px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F23310i498C2DAAEFE8DD1C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%2288ab4585-9916-4909-a3b0-85bcd43e3900%22%20title%3D%2288ab4585-9916-4909-a3b0-85bcd43e3900%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20this%20presentation%20may%20be%20of%20interest%26nbsp%3B%20-%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Ignite-Content-2017%2FUnderstand-how-your-users-are-using-Office-365-What-s-new-in%2Fm-p%2F98551%22%20target%3D%22_blank%22%3E%26nbsp%3BUnderstand%20how%20your%20users%20are%20using%20Office%20365%3A%20What%E2%80%99s%20new%20in%20usage.%20reporting%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123051%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123051%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20does%20that%20give%20you%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123049%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123049%22%20slang%3D%22en-US%22%3ETake%20a%20look%20also%20at%20the%20Power%20BI%20Adoption%20Pack%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123038%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20and%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123038%22%20slang%3D%22en-US%22%3E%3CP%3ESupport's%20coming%20next%20year%2C%20if%20you%20haven't%20seen%20this%20already%2C%20at%20least%20in%20PowerBI%20with%20Office%20365%20Usage%20Analytics%20and%20whatever%20custom%20reports%20will%20be%20supported%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-365-Blog%2FWhat-s-new-in-Office-365-Usage-Reporting-Ignite-Edition%2Fba-p%2F109157%22%20target%3D%22_blank%22%3EWhat%E2%80%99s%20new%20in%20Office%20365%20Usage%20Reporting%20%E2%80%93%20Ignite%20Edition%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EVisualize%20and%20analyze%20usage%20in%20PowerBI%20with%20Office%20365%20Usage%20Analytics%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EOffice%20365%20Usage%20Analytics%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B-%20currently%20available%20as%20preview%20as%20Office%20365%20Adoption%20Content%20Pack%20in%20PowerBI%20-%20combines%20the%20intelligence%20of%20the%20usage%20reports%20with%20the%20interactive%20analysis%20capabilities%20of%20Power%20BI%2C%20providing%20a%20wealth%20of%20usage%20and%20adoption%20insights.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EAt%20the%20beginning%20of%202018%2C%20the%20content%20pack%20will%20be%20renamed%20to%20Usage%20Analytics%20and%20will%20reach%20general%20availability%20with%20an%20updated%20version%20that%20will%20include%20new%20metrics%20on%20teamwork%20and%20collaboration%2C%20usage%20data%20for%20%3CSTRONG%3EMicrosoft%20Teams%3C%2FSTRONG%3E%2C%20Yammer%20Groups%20and%20Office%20365%20Groups%2C%20and%20more.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Darren Welldon
New Contributor

I am wanting to look at reporting on data that is held within Microsoft Teams but it appears that there are no connectors for this with power BI

 

Is there a way of achieving this?

5 Replies

Support's coming next year, if you haven't seen this already, at least in PowerBI with Office 365 Usage Analytics and whatever custom reports will be supported:

 

What’s new in Office 365 Usage Reporting – Ignite Edition

 

Visualize and analyze usage in PowerBI with Office 365 Usage Analytics

 

Office 365 Usage Analytics - currently available as preview as Office 365 Adoption Content Pack in PowerBI - combines the intelligence of the usage reports with the interactive analysis capabilities of Power BI, providing a wealth of usage and adoption insights. 


At the beginning of 2018, the content pack will be renamed to Usage Analytics and will reach general availability with an updated version that will include new metrics on teamwork and collaboration, usage data for Microsoft Teams, Yammer Groups and Office 365 Groups, and more.

Take a look also at the Power BI Adoption Pack

What does that give you ?

Check it out - Office 365 Adoption content pack and Enable the Power BI Adoption content pack for Office 365.

 

Per above, it's being renamed to Office 365 Usage Analytics with support for Teams in the new year.

 

88ab4585-9916-4909-a3b0-85bcd43e3900

 

Also, this presentation may be of interest  - Understand how your users are using Office 365: What’s new in usage. reporting.

Hi,
what data are you looking for?

If you alreaddy have the data, but want to push them to power bi, take a look at my blogpost on conencting PowerShell and powerbi.
https://alexholmeset.blog/2018/02/11/office-365-groups-reporting-and-power-bi-visualisation/

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies