Home

How to add M365 Usage Analytics PBI Report as tab in Advisor for Teams team? (permissions)

%3CLINGO-SUB%20id%3D%22lingo-sub-1168262%22%20slang%3D%22en-US%22%3EHow%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168262%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20--%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20trying%20to%20leverage%20two%20key%20Microsoft%20adoption%20resources%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fadmin%2Fusage-analytics%2Fusage-analytics%3Fview%3Do365-worldwide%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EM365%20Usage%20Analytics%3C%2FA%3E%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fuse-advisor-teams-roll-out%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdvisor%20for%20Teams%3C%2FA%3E.%20We%20have%20created%20the%20team%2C%20and%20we%20have%20acquired%20the%20M365%20Usage%20Analytics%20app.%26nbsp%3B%20We%20added%20a%20PBI%20tab%20in%20the%20team%2C%20but%20we%20seem%20to%20have%20a%20permissions%20issue%20--%20other%20team%20members%20are%20unable%20to%20view%20the%20PBI%20tab%20content.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20skilled%20end%20users%20but%20not%20too%20experienced%20in%20Power%20BI.%26nbsp%3B%20I%20think%20what's%20happening%20is%20I'm%20forced%20to%20save%20the%20M365%20Usage%20Analytics%20to%20MyWorkspace%20(to%20which%20team%20members%20lack%20permissions).%26nbsp%3B%20I'd%20like%20to%20publish%20to%20the%20Advisor%20to%20Teams%20workspace%2C%20so%20permissions%20take%20care%20of%20themselves%20as%20members%20are%20added%20to%20the%20Advisor%20for%20Teams%20team.%26nbsp%3B%20Yes%2FNo%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20any%20and%20all%20guidance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F27835%22%20target%3D%22_blank%22%3E%40Karuana%20Gatimu%3C%2FA%3E%2C%20perhaps%20the%20M365%20Usage%20Analytics%20documentation%20can%20be%20updated%20with%20step-by-step%20guidance%20(at%20least%20when%20Advisor%20for%20Teams%20exits%20preview).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKris%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1168262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdvisor%20for%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172097%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172097%22%20slang%3D%22en-US%22%3EHello%20Kris%3CBR%20%2F%3E%3CBR%20%2F%3EUsers%20who%20want%20to%20view%20the%20dashboard%20(so%20I%20guess%20all%20the%20members%20of%20the%20team)%20need%20to%20have%20a%20Power%20BI%20Pro%20or%20Power%20BI%20Premium%20license%20assigned.%20So%20it%20is%20not%20sufficient%20that%20only%20the%20user%20sharing%20the%20report%20has%20the%20pro%20license.%3CBR%20%2F%3E%3CBR%20%2F%3EHth%3CBR%20%2F%3EStefan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182719%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411248%22%20target%3D%22_blank%22%3E%40Kris925%3C%2FA%3E%26nbsp%3B%20-%20I%20went%20through%20the%20exercise%20of%20setting%20this%20up%20on%20my%20Developer%20Tenant%20(E5%20anyone%20can%20get%20if%20they%20are%20learning%20or%20testing%2C%20etc%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FO365DevProgram%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FO365DevProgram%3C%2FA%3E%26nbsp%3B)%26nbsp%3B%20and%20in%20the%20process%20ran%20into%20issues%20that%20even%20I%20as%20a%20Developer%20and%20Architect%20required%20me%20to%20open%20a%20support%20ticket%20(no%20cost!)%20asking%20for%20a%20walk%20through%20to%20discover%20that%20the%20document%20was%20actually%20missing%20a%20step%20(updated%20since%2C%20thank%20you%20Microsoft!)%26nbsp%3B%20and%20seeing%20how%20very%20sophisticated%20and%20complex%20it%20is.%26nbsp%3B%20Potentially%2C%20support%20should%20be%20able%20to%20walk%20you%20through%20making%20it%20available%20to%20the%20other%20workspace%20but%20as%20noted%2C%20licensing%20may%20prevent%20viewership%20...%20unless%20it%20is%20moved%20to%20something%20more%20%22static%22%20like%20Excel%20which%20can%20be%20set%20up%20and%20pinned%20in%20Teams%20or%20SharePoint%20...%20perhaps%20for%20adoptions%20sake%2C%20we%20can%20get%20some%20guidance%20(or%20blog)%20on%20how%20to%20%22share%22%20the%20analytics%20report%20in%20a%20static%20or%20%22delayed%22%20fashion%20that%20is%20still%20functional.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182762%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182762%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F44882%22%20target%3D%22_blank%22%3E%40Stefan%20Fried%3C%2FA%3E.%26nbsp%3B%20Very%20good%20point%20re%20licenses.%26nbsp%3B%20Our%20team%20members%20do%20have%20the%20necessary%20licenses%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182774%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182774%22%20slang%3D%22en-US%22%3E%3CP%3EWow%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491%22%20target%3D%22_blank%22%3E%40Ralph%20Rivas%3C%2FA%3E...thank%20you%20for%20your%20efforts%20and%20for%20sharing.%26nbsp%3B%20Thankful%20we%20weren't%20missing%20the%20obvious.%26nbsp%3B%20Will%20revisit%20the%20now-updated%20instructions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182793%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20M365%20Usage%20Analytics%20PBI%20Report%20as%20tab%20in%20Advisor%20for%20Teams%20team%3F%20(permissions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411248%22%20target%3D%22_blank%22%3E%40Kris925%3C%2FA%3E%26nbsp%3B%20-%20just%20for%20posterity%2C%20there%20were%20two%20things%20that%20came%20up%20in%20that%20call%20...%20one%20was%20there%20was%20a%20check%20box%20for%20the%20%22new%20experience%22%20(or%20some%20wording%20to%20that%20effect)%20which%20originally%20made%20it%20hard%20to%20follow%20along%20with%20the%20support%20person%26nbsp%3B%20(buttons%20and%20wording%20mismatched%20until%20I%20clicked%20it)%20...%20the%20second%20was%20an%20%22assumption%22%20that%20we%20knew%20what%20authorization%20type%20was%20permitted%20and%20skipped%20that%20screen%20selection%20...%20now%20its%20there%20and%20with%20that%20one%20two%2C%20voila%2C%20report!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi --

 

We are trying to leverage two key Microsoft adoption resources: M365 Usage Analytics and Advisor for Teams. We have created the team, and we have acquired the M365 Usage Analytics app.  We added a PBI tab in the team, but we seem to have a permissions issue -- other team members are unable to view the PBI tab content.  

 

We are skilled end users but not too experienced in Power BI.  I think what's happening is I'm forced to save the M365 Usage Analytics to MyWorkspace (to which team members lack permissions).  I'd like to publish to the Advisor to Teams workspace, so permissions take care of themselves as members are added to the Advisor for Teams team.  Yes/No?  

 

Would appreciate any and all guidance. 

 

@Karuana Gatimu, perhaps the M365 Usage Analytics documentation can be updated with step-by-step guidance (at least when Advisor for Teams exits preview).

 

 

Thank you!

 

Kris

 

5 Replies
Highlighted
Hello Kris

Users who want to view the dashboard (so I guess all the members of the team) need to have a Power BI Pro or Power BI Premium license assigned. So it is not sufficient that only the user sharing the report has the pro license.

Hth
Stefan
Highlighted

@Kris925  - I went through the exercise of setting this up on my Developer Tenant (E5 anyone can get if they are learning or testing, etc https://aka.ms/O365DevProgram )  and in the process ran into issues that even I as a Developer and Architect required me to open a support ticket (no cost!) asking for a walk through to discover that the document was actually missing a step (updated since, thank you Microsoft!)  and seeing how very sophisticated and complex it is.  Potentially, support should be able to walk you through making it available to the other workspace but as noted, licensing may prevent viewership ... unless it is moved to something more "static" like Excel which can be set up and pinned in Teams or SharePoint ... perhaps for adoptions sake, we can get some guidance (or blog) on how to "share" the analytics report in a static or "delayed" fashion that is still functional.  

Highlighted

Thank you, @Stefan Fried.  Very good point re licenses.  Our team members do have the necessary licenses though.

Highlighted

Wow, @Ralph Rivas...thank you for your efforts and for sharing.  Thankful we weren't missing the obvious.  Will revisit the now-updated instructions.

 

Thanks again! 

Highlighted

@Kris925  - just for posterity, there were two things that came up in that call ... one was there was a check box for the "new experience" (or some wording to that effect) which originally made it hard to follow along with the support person  (buttons and wording mismatched until I clicked it) ... the second was an "assumption" that we knew what authorization type was permitted and skipped that screen selection ... now its there and with that one two, voila, report!  

Related Conversations
Contact sync issues with teams
Chris_S017 in Microsoft Teams on
2 Replies
Team stream recordings are flipped horizontally?
Jgq85 in Microsoft Teams on
0 Replies
Elettronic attendance register
Liborio1610 in Microsoft Teams on
0 Replies
Change Calendar in Teams
jonasbayer in Microsoft Teams on
3 Replies