SOLVED

Ms Teams - Report Team Names

%3CLINGO-SUB%20id%3D%22lingo-sub-284299%22%20slang%3D%22en-US%22%3EMs%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284299%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20way%20I%20can%20generate%20a%20report%20using%20power%20BI%20or%20push%20all%20team%20details%20(including%20public%20and%20private)%20in%20real%20time%20in%20the%20SharePoint%20list.%3CBR%20%2F%3E%3CBR%20%2F%3ERequirement%20is%20to%20provide%20access%20to%20champions%20(team%20creators)%20for%20list%20of%20existing%20teams%20name%20on%20real%20time%20basis%20so%20that%20before%20creationg%20a%20team%20they%20can%20validate%20if%20the%20team%20name%20exist%20to%20avoid%20duplicacy%3F%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20share%20if%20you%20have%20any%20better%20suggestions%20to%20achieve%20the%20above%20requirements%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-284299%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-285845%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285845%22%20slang%3D%22en-US%22%3E%3CP%3Ethid%20feature%20was%20on%20a%20roll-out%20but%20withdrawn%20due%20to%20security%20complaints..Im%20not%20really%20sure%20if%20they%20will%20keep%20the%20private%20teams%20hidden%20or%20not%20from%20teams%20%2C%20but%20they%20will%20be%20visible%20from%20an%20admin%20perspective%20in%20the%20portal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285841%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285841%22%20slang%3D%22en-US%22%3E%3CP%3EI%20believe%20(from%20Ignite)%20that%20Microsoft%20intends%20to%20allow%20private%20teams%20to%20be%20discoverable%20(within%20the%20Teams%20client%2C%20not%20Outlook).%20However%2C%26nbsp%3Bprivate%20teams%20remain%20closed%20as%20any%20request%20to%20join%20must%20be%20approved%20by%20a%20team%20owner.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285742%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285742%22%20slang%3D%22en-US%22%3EThe%20new%20teams%20tab%20in%20the%20Skype%20and%20teams%20admin%20center%20will%20list%20all%20teams%20in%20your%20tenant%20yes!%20Not%20there%20yet%20though%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285739%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285739%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20seems%20with%20the%20new%20search%20policy%20you%20can%20search%20the%20private%20team%20from%20team%20search%20function%20or%20outlook%20however%2C%20it%E2%80%99s%20not%20been%20roll-out%20to%20all%20tenants.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20confirm%20the%20change%20please%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285136%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285136%22%20slang%3D%22en-US%22%3EHi!%20For%20more%20information%20about%20Power%20BI%20and%20csv%E2%80%99s%2C%20see%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsv-se%2Fpower-bi%2Fservice-comma-separated-value-files%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fsv-se%2Fpower-bi%2Fservice-comma-separated-value-files%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20it%20comes%20to%20licensing%2C%20this%20is%20a%20good%20blogpost%20explaining%20this%3A%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fradacad.com%2Fpower-bi-licensing-walk-through-guide%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fradacad.com%2Fpower-bi-licensing-walk-through-guide%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBasically%2C%20to%20share%20a%20report%20in%20a%20secure%20way%20for%20your%20users%20you%20need%20a%20paid%20subscription%20and%20also%20for%20the%20users%20who%20will%20consume%20the%20BI%20reports%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285122%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285122%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20need%20to%20be%20a%20tenant%20administrator%20or%20a%20Teams%20service%20administrator%20to%20run%20Get-Team%20to%20retrieve%20a%20list%20of%20teams.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20store%20the%20CSV%20file%20wherever%20you%20like.%20The%20script%20uses%20c%3A%5Ctemp%20for%20now.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20to%20Power%20BI%2C%20I%20am%20not%20a%20Power%20BI%20guy.%20All%20you%20asked%20was%20for%20a%20way%20to%20get%20the%20data%20into%20Power%20BI...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285120%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285120%22%20slang%3D%22en-US%22%3EThanks%20Tony.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20are%20the%20permissions%20required%20to%20run%20the%20powershell%3F%20Where%20are%20you%20storing%20the%20CSV%20file%20and%20is%20it%20overwriting%20the%20CSV%20in%20next%20schedule%20run%3F%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20auto%20update%20of%20power%20BI%20report%20will%20happen%20or%20a%20update%20of%20CSV%20file%20if%20a%20configure%20%2Fpin%20a%20tab%20of%20CSV%20file%20in%20Teams%3F%20Should%20we%20need%20to%20write%20another%20script%20to%20upload%20and%20overwrite%20the%20CSV%20in%20team%20SharePoint%20Online%20file%20share%20library%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20licensing%20requirements%20required%20for%20users%20to%20view%20the%20report%20in%20power%20BI%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285093%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285093%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20a%20script%20to%20get%20you%20going%3A%26nbsp%3B%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Foffice365foritpros.com%2F2018%2F11%2F11%2Fexporting-teams-powerbi%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365foritpros.com%2F2018%2F11%2F11%2Fexporting-teams-powerbi%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285081%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285081%22%20slang%3D%22en-US%22%3E%3CP%3ETake%20a%20look%20at%20feature%2042620%20on%20the%20Roadmap%2C%20this%20could%20be%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285067%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285067%22%20slang%3D%22en-US%22%3EYou%20can%20run%20it%20as%20a%20scheduled%20task!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F38580.configure-to-run-a-powershell-script-into-task-scheduler.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F38580.configure-to-run-a-powershell-script-into-task-scheduler.aspx%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20have%20your%20file%20on%20sharepoint%20and%20configure%20PowerBI%20to%20fetch%20data%20on%20a%20regular%20basis!%20This%20way%20the%20dashboards%20will%20show%20the%20latest%20changes!%3CBR%20%2F%3EJust%20search%20for%20this%20and%20you%20will%20find%20a%20lot%20of%20help%20to%20guide%20you%20step%20by%20step%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99ll%20try%20to%20put%20this%20together%20myself%20someday%20next%20week!%20I%E2%80%99ll%20let%20you%20know%20how%20that%20goes!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285036%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285036%22%20slang%3D%22en-US%22%3EHi%20Adam%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%20I%20am%20just%20trying%20to%20understand%20as%20per%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20What%20are%20the%20ways%20to%20to%20schedule%20the%20powershell%20to%20auto%20run%3F%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Should%20we%20overwrite%20the%20excel%20file%20at%20every%20schedule%20run%20and%20is%20there%20any%20manual%20intervention%20required%20to%20update%20back%20in%20power%20BI%20once%20the%20excel%20file%20get%20updated%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285033%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285033%22%20slang%3D%22en-US%22%3EIf%20you%20run%20a%20powershell%20script%20and%20then%20export%20the%20result%20to%20an%20excel%20file%2C%20say%20the%20names%20and%20status%20of%20the%20groups%20which%20is%20teamified%20-%20it%E2%80%99s%20quite%20easy%20to%20then%20use%20this%20file%20as%20a%20data%20source%20for%20PowerBI.%20This%20report%20can%20be%20viewed%20%2C%20or%20excel%20file%20directly%2C%20by%20the%20champions.%20You%20can%20embed%20the%20PowerBI%20report%20in%20sharepoint%2C%20as%20a%20tab%20in%20teams%2C%20or%20via%20a%20link%20for%20view!%3CBR%20%2F%3EKeep%20in%20mind%20that%20this%20powershell%20script%20must%20be%20scheduled%20to%20run%20quite%20often%20to%20have%20your%20excel%20file%20and%20report%20up%20to%20date%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285025%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285025%22%20slang%3D%22en-US%22%3EHi%20Tony%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20response.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20I%20can%20provide%20the%20real%20time%20report%20to%20champions%20(end-users%20team%20creators)%20using%20the%20combination%20of%20powershell%2C%20excel%20and%20power%20bi%20as%20per%20your%20last%20reply%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284941%22%20slang%3D%22en-US%22%3ERE%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284941%22%20slang%3D%22en-US%22%3EYou%20can%20use%20PowerShell%20to%20grab%20all%20the%20team%20information%20and%20send%20it%20to%20Excel%2C%20then%20import%20the%20Excel%20into%20Power%20BI.%20An%20easy%20script%20to%20write...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284320%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284320%22%20slang%3D%22en-US%22%3EYeah%20here%20is%20the%20uservoice%20I%20saw%20come%20across%20with%20an%20update%20for%20it.%20They%20have%20it%20in%20TAP%20currently%2C%20so%20if%20it's%20good%20we%20might%20see%20it%20before%20too%20long.%20%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F20168716-reporting-capabilities%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F20168716-reporting-capabilities%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284319%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Teams%20-%20Report%20Team%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284319%22%20slang%3D%22en-US%22%3ENothing%20in%20place%20for%20that.%20They%20are%20working%20on%20that%20and%20if%20I%20remember%20right%20they%20are%20starting%20to%20test%20the%20reporting%20features%20they%20are%20adding%20with%20some%20early%20rings.%20You%20are%20probably%20better%20off%20waiting%20for%20the%20built%20in%20reports%20that%20Team%20owners%20can%20view%20that%20they%20are%20adding%20in%20instead%20of%20trying%20to%20build%20something%20that%20pretty%20much%20impossible%20to%20build%20at%20this%20point%20%3A).%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor
Hi all,

Is there way I can generate a report using power BI or push all team details (including public and private) in real time in the SharePoint list.

Requirement is to provide access to champions (team creators) for list of existing teams name on real time basis so that before creationg a team they can validate if the team name exist to avoid duplicacy?

Please share if you have any better suggestions to achieve the above requirements?
16 Replies
Highlighted
Nothing in place for that. They are working on that and if I remember right they are starting to test the reporting features they are adding with some early rings. You are probably better off waiting for the built in reports that Team owners can view that they are adding in instead of trying to build something that pretty much impossible to build at this point :).
Highlighted
Yeah here is the uservoice I saw come across with an update for it. They have it in TAP currently, so if it's good we might see it before too long. https://microsoftteams.uservoice.com/forums/555103-public/suggestions/20168716-reporting-capabilitie...
Highlighted
You can use PowerShell to grab all the team information and send it to Excel, then import the Excel into Power BI. An easy script to write...
Highlighted
Hi Tony,

Thanks for your response.

How can I can provide the real time report to champions (end-users team creators) using the combination of powershell, excel and power bi as per your last reply?

Many thanks.
Highlighted
If you run a powershell script and then export the result to an excel file, say the names and status of the groups which is teamified - it’s quite easy to then use this file as a data source for PowerBI. This report can be viewed , or excel file directly, by the champions. You can embed the PowerBI report in sharepoint, as a tab in teams, or via a link for view!
Keep in mind that this powershell script must be scheduled to run quite often to have your excel file and report up to date

Adam
Highlighted
Hi Adam,

Thank you. I am just trying to understand as per below:

1. What are the ways to to schedule the powershell to auto run?

2. Should we overwrite the excel file at every schedule run and is there any manual intervention required to update back in power BI once the excel file get updated?

Many thanks!
Highlighted
You can run it as a scheduled task!

https://social.technet.microsoft.com/wiki/contents/articles/38580.configure-to-run-a-powershell-scri...

You have your file on sharepoint and configure PowerBI to fetch data on a regular basis! This way the dashboards will show the latest changes!
Just search for this and you will find a lot of help to guide you step by step

I’ll try to put this together myself someday next week! I’ll let you know how that goes!!
Highlighted

Take a look at feature 42620 on the Roadmap, this could be helpful.

Highlighted
Best Response confirmed by Tony Redmond (MVP)
Highlighted
Thanks Tony.

What are the permissions required to run the powershell? Where are you storing the CSV file and is it overwriting the CSV in next schedule run?

How auto update of power BI report will happen or a update of CSV file if a configure /pin a tab of CSV file in Teams? Should we need to write another script to upload and overwrite the CSV in team SharePoint Online file share library?

Is there licensing requirements required for users to view the report in power BI?

Many thanks!
Highlighted

You need to be a tenant administrator or a Teams service administrator to run Get-Team to retrieve a list of teams. 

 

You can store the CSV file wherever you like. The script uses c:\temp for now.

 

As to Power BI, I am not a Power BI guy. All you asked was for a way to get the data into Power BI...

Highlighted
Hi! For more information about Power BI and csv’s, see:
https://docs.microsoft.com/sv-se/power-bi/service-comma-separated-value-files

When it comes to licensing, this is a good blogpost explaining this:
http://radacad.com/power-bi-licensing-walk-through-guide

Basically, to share a report in a secure way for your users you need a paid subscription and also for the users who will consume the BI reports

Adam
Highlighted
Hi all,

It seems with the new search policy you can search the private team from team search function or outlook however, it’s not been roll-out to all tenants.

Can anyone confirm the change please?

Thank you.

Highlighted
The new teams tab in the Skype and teams admin center will list all teams in your tenant yes! Not there yet though
Highlighted

I believe (from Ignite) that Microsoft intends to allow private teams to be discoverable (within the Teams client, not Outlook). However, private teams remain closed as any request to join must be approved by a team owner.

Highlighted

thid feature was on a roll-out but withdrawn due to security complaints..Im not really sure if they will keep the private teams hidden or not from teams , but they will be visible from an admin perspective in the portal