What we do
Tools
Industries
Department
How we workLet's talk →
Home/MS Teams/Teams Dashboards
Microsoft Teams

Teams Dashboards: Where Microsoft Keeps Teams Usage, and Which One to Open

There isn't one Teams dashboard. Usage sits in the Teams admin center, in the Microsoft 365 admin center reports, and in a Power BI template app called Microsoft 365 usage analytics. They overlap, but each answers a different question, and all three hide people's names by default.

Teams usage, by place

Teams admin center: Analytics & reports, then Usage reports. Pick a report and date range, then Run report.

Analytics & reports Usage reports Run report

Microsoft 365 admin center: Reports, then Usage, then Microsoft Teams. The User activity tab shows trends over 7, 30, 90 or 180 days and exports to CSV.

Reports Usage Microsoft Teams

Power BI: the Microsoft 365 usage analytics template app gives a prebuilt dashboard with 12 months of history. It needs a Power BI Pro license and a Global administrator to switch it on.

Switch on the Power BI usage dashboard

This is the closest thing to a ready-made Teams dashboard Microsoft offers.

  1. 1

    Make the data available

    Settings Org settings Services Reports

    As a Global administrator in the Microsoft 365 admin center, tick Make report data available to Microsoft 365 usage analytics for Power BI and save.

  2. 2

    Wait for collection

    Microsoft says this takes 2 to 48 hours depending on tenant size. The Go to Power BI button on the Usage page stops being gray when it's ready. Copy the tenant ID shown there.

  3. 3

    Install the app in Power BI

    Apps Get apps Microsoft 365 usage analytics

    Search for Microsoft 365, choose Microsoft 365 usage analytics and Get it now. You need a Power BI Pro license to install it, and the people you share it with need one too unless it sits in a Premium workspace.

  4. 4

    Connect it to your tenant

    Open the app, choose Connect, paste the tenant ID without dashes, and sign in with OAuth2. Other sign-in methods make the connection fail. The first load takes a few minutes.

    Watch for: the Teams page inside the app is one of several product reports. Adoption, communication and mobility tabs also include Teams figures.

Why your Teams report shows strings of letters instead of people

Names are concealed by default

How you'll know: User names, team names and emails show as hashes in every report and export.

Fix: Since September 2021 Microsoft hides them by default. A Global administrator can untick Display concealed user, group, and site names in all reports under Org settings, Services, Reports. It applies to both admin centers, Microsoft Graph and Power BI, and the change is recorded in the Microsoft Purview audit log. Check your privacy policy and works council rules first.

Messages sent by apps don't count

How you'll know: A channel that's busy with bot posts or forwarded emails shows almost no activity.

Fix: Microsoft's counts cover what people do in the Teams client. Posts from Teams apps and emails sent into channels aren't included.

Yesterday's numbers changed

How you'll know: Last week's figures shift slightly when you look again.

Fix: Microsoft re-checks the last three days of data daily and fills gaps. Report on periods that are at least a few days old.

Teams usage next to the rest of the business

The admin center answers "is Teams being used?". It doesn't answer "is the sales team using it more since we moved off email?" or "which offices still haven't switched?", because that needs your own data: departments from HR, regions from payroll, deals from the CRM. There's also no setting that schedules a report export to a shared drive, so someone downloads the CSV by hand.

n-frames builds that reporting. A scheduled job pulls the Teams user activity detail from Microsoft Graph's reports API, joins it to your HR list, and lands it in a Power BI dataset or the dashboard your managers already open, with a weekly flag when a department's activity drops. Related builds: Teams and Power Automate, Teams bots and channel setup. For calling data, see the Teams Phone page.

Which Teams dashboard answers which question

You need to know Open Watch for
Is Teams actually being used, and on what devices? The Teams usage, user activity and device usage reports in the Teams admin center. A Global reader sees tenant totals only, with no per-user or per-team rows.
Month-on-month adoption for a leadership pack The Microsoft 365 usage analytics app in Power BI. User-level detail covers the last full calendar month, and only appears around the 5th of the month after you switch it on.
Are we getting value from Teams Premium? The Teams Premium feature usage report: users reached and meetings that used features like intelligent recap, watermarks or live translated captions. Data usually lands 24 to 48 hours after use. Not available in government clouds.
Phone minutes and call charges The PSTN usage and PSTN minute pools reports. These are for organizations on Teams Phone. Call quality for one bad call is a different tool (see the FAQ).
Usage by department, region or cost center, next to HR or sales data Microsoft Graph usage reports joined with your own data in Power BI or your BI tool. Microsoft removed the Company, City and ProxyAddresses filters from the usage analytics app and now suggests this route instead.

Questions people ask

Can I see which specific person is using Microsoft Teams the most?

Yes, once names are shown. Reports conceal user identities by default. A Global administrator turns that off in the Microsoft 365 admin center under Org settings, Services, Reports, and then the user activity report lists each person with their messages, calls and meetings.

Can I export Microsoft Teams usage data automatically on a schedule?

Not from the admin centers, which offer a manual Export to CSV. For an automatic export, either use the Power BI usage analytics app, which refreshes on Microsoft's schedule, or build a job against Microsoft Graph's reports API.

What's the difference between Teams call analytics and call records?

Call analytics shows quality detail for one specific call or meeting, useful when someone says the audio kept dropping. Call records are the broader who-called-whom-and-for-how-long data, pulled through Microsoft Graph's cloud communications API. PSTN usage reports in the admin center cover phone-number calls and charges.

How far back does Microsoft Teams usage data go?

It depends on where you look. The Teams user activity report in the Microsoft 365 admin center shows trends over 7, 30, 90 or 180 days, and its daily table goes back up to 28 days. The Power BI usage analytics app shows 12 months for most reports. Teams admin center reports each have their own ranges, so check the one you need.

Is there a Power BI integration for Microsoft Teams usage?

Yes. Microsoft 365 usage analytics is a Power BI template app with a prebuilt dashboard covering Teams and the other Microsoft 365 services. For anything it doesn't slice the way you need, the Graph reports API can feed your own Power BI report.

Can n-frames build a Teams usage dashboard by department?

Yes. n-frames pulls Teams activity from Microsoft Graph, matches each person to their department and location from your HR system, and builds the Power BI report or dashboard view leadership asked for, refreshed on a schedule.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.