Personal Teams Report in Power BI | Teams Nation Give away

During Teams Nation in May 2021 I had the great honor of talking in the Adoption room in regards to how Power BI could be used to drive Adoption of Microsoft Teams. It had a twist though! Instead of using the insight in a Power BI report, I talked about how the actual product of Power BI and example reports used by the end users inside Teams could drive the adoption of Teams itself.

A free digital give away was promised and via this blog post it is now also delivered!

Say hi to the Personal Teams Report in Power BI! A Power BI Template that, once opened in Power BI Desktop, will prompt you to log in against the rather newly released Personal Teams Connector. Use your Office 365 account and boom – insights available!

You can use this link to download the report right away!

If you have any feedback, please feel free to reach out! This Power BI report was built by myself and my colleague Mathilda Bäckman.


The first page sums up your personal usage of Microsoft Teams like this. There are 15 functions being measured and you get a nice list showing which ones you’ve been using in the period and all, if any, you are missing out on.

I figured it’s easier to look into details on functions when you know they exists. It’s hard to know what you didn’t know that you didn’t know.

This view also focus somewhat on Audio and Video ratio. Since it’s the ratio being measured, it matters less if you’ve had like 15 hours of video in the last 90 days. If you’ve had audio on for 30 hours, you’re still only utilizing video during 50% of your collaborative time. If you’re OK with this metric it’s all good. If not, you have the choice and power to make a change!

The next section focus on the usage in Teams you are a member of!

The Active users show how many users in this team that has been active in the same day during the period. The same goes for channels but the rest of the usage is summed up.

Using this insight, you can determine if you want to stay inside inactive teams or if they are just taking up space in your menu of what I assume is a pretty impressive list of Teams already.

It’s also kind of cool to imagine the amount of channel messages being created around you! Don’t let it scare you if you have a high number. Teach your fellow Teams user to make use of the Mention-function in Teams. That way you will only focus on what’s important to you personally, The rest is just buzz. That buzz might not be important right now but this might change in the future! For example: 2 of your peers are discussing the best parking spots at another office than the one you’re stationed at. Not very interesting for you at the moment and so it just passes you by. But a month into the future you intend to visit said office and suddenly parking preference at this other office has popped up on your priority radar. Using the search bar in Microsoft Teams, you can get the information you need, when you need it.

The last page is a summary of you teams settings and amount of members.

Using this tab you can get a quick overview of the teams you are a member of, the amount of users and guests in them as well as the privacy level of the team.

This is useful of you want to clean up the list of teams you’re a member of, or perhaps you want to simply hide a Team or 2 so that they are still searchable but not mixed with your active teams.

At the end of the day, change can only come from within and you are ultimately unable to change anybody except yourself. As a Power BI FTRSA I often work with strategic and tactical levels in organizations where we look at data to get insights on larger groups of users that we can direct onboarding and adoption activities towards. This is a great way to lead and guide the culture of your organization and set a clear course for your employees, but I hope that this report can give a refreshing perspective. From a centralized perspective, measuring a higher teams usage is done under the assumption that it means a more effective way of work. From your own perspective, using the potential available in your tool box could lead to less stress, more control and all in all a better life.

The power is now in your hands. You have your own insights. Will you accept it as is or do you see potential for improvements? If so, will you take action towards it?

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *