How to Get Data in Power BI from Microsoft Teams

Pulling your Microsoft Teams data into a Power BI dashboard lets you see exactly how your team collaborates. Instead of relying on gut feelings, you can analyze user activity, track project updates in real-time, and build reports directly from the lists and files your team already uses. This article will show you several ways to connect Power BI to Microsoft Teams, from the simplest automated method to more customized approaches.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Visualize Microsoft Teams Data in the First Place?

Connecting Teams to Power BI transforms your communication hub into a valuable data source. When your collaboration data is visualized, you can stop guessing and start making informed decisions about productivity, engagement, and project health. It helps you answer essential questions that are otherwise hard to track down.

Here are just a few of the insights you can unlock:

• User Adoption and Engagement: Identify your most active users and channels, or spot teams that might need more training or encouragement to embrace the platform. Reports can show trends in chat messages, calls, and meetings over time.
• Channel and Project Activity: See which projects or departments are driving the most conversation and collaboration. If you have a separate team for each major project, you can easily track and compare their communication cadence.
• Meeting Analytics: Analyze the frequency, duration, and attendance of meetings across your organization to identify trends in how people are collaborating.
• Centralized Project Tracking: Pull data from lists (like task trackers or issue logs) and files (like budgets or status reports) used within Teams channels to create consolidated project dashboards.

Ultimately, it’s about making your team’s collaborative work visible and measurable. This allows you to improve processes, spot bottlenecks, and ensure everyone is aligned and engaged.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Connect Power BI and Microsoft Teams

There are several ways to get data from Microsoft Teams into Power BI, each suited for different use cases. We’ll cover the most common and practical methods, starting with the easiest.

Method 1: Use a Power BI Template App (The Easiest Way)

Microsoft offers a pre-built template app called "Microsoft 365 Usage Analytics" that pulls in data from across the M365 suite, including Microsoft Teams. This is by far the simplest way to get a comprehensive overview of usage and adoption without needing any technical skills. The dashboards and reports are already built for you.

Before You Start: Prerequisites

To use this method, you need to be a Microsoft 365 Global admin, Exchange admin, SharePoint admin, Skype for Business admin, Global reader, or Reports reader. You also need to have a Power BI Pro or Premium subscription. If you’re not an admin, you may need to ask someone from your IT department for assistance.

Step-by-Step Instructions

1. Access the App from Power BI Service Log in to your Power BI account at app.powerbi.com. In the navigation pane on the left, click on Apps, then click the Get apps button in the upper-right corner.
2. Find the Microsoft 365 Usage Analytics App In the Power BI AppSource marketplace, use the search bar to look for "Microsoft 365 Usage Analytics." Once you find it, click on it and then select Get it now. You may need to fill in some profile information before proceeding.
3. Connect to Your Data Source After installing the app, Power BI will prompt you to connect it to your data. Click the Connect data link. Here, you'll need your Tenant ID. This unique identifier tells Power BI which Microsoft 365 account to pull data from. You can find your Tenant ID in your Azure Active Directory portal under "Properties" or ask your IT admin for it. Once you've entered the ID, you will authenticate using your Microsoft 365 credentials (this is called OAuth).
4. Explore the Pre-Built Reports Power BI will now begin importing the usage data from your tenant. This can take anywhere from a few minutes to several hours, depending on the size of your organization. Once it's complete, your workspace will contain a new dashboard, report, and dataset. Click on the report to explore detailed breakdowns of Teams activity, including user activity, device usage, and more.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Connect to a SharePoint List Used in a Teams Channel

A very common workflow is managing data in a list directly within a Teams channel - for example, a project task tracker, an inventory list, or a simple issue log. Because every Team has an underlying SharePoint site, this list data is readily available to connect to Power BI Desktop.

Step-by-Step Instructions

1. Find Your SharePoint Site URL Navigate to the team and channel containing the list you want to analyze. Click on the Files tab. Here, click the three dots (...) and select Open in SharePoint. This will open the connected SharePoint site in your web browser. Copy the root URL of this site - it will look something like https://yourcompany.sharepoint.com/sites/YourTeamName.
2. Connect from Power BI Desktop Open the Power BI Desktop application. Go to the Home tab, click Get Data, select More..., and then search for and select SharePoint Online list. Click Connect.
3. Provide the URL and Sign In In the pop-up window, paste the SharePoint site URL you copied earlier. Power BI will then prompt you to sign in. Use your Microsoft account credentials that you use for Teams and SharePoint.
4. Select and Load Your List Once you've successfully authenticated, a Navigator window will appear, showing all the available lists on that SharePoint site. Find and check the box next to the name of the list you want to import. To make any adjustments before loading, click Transform Data to open the Power Query Editor. Here you can filter, rename columns, and clean your data before clicking Close & Apply.

Method 3: Connect to an Excel or CSV File Stored in Teams

If your team uses an Excel sheet or CSV file to track data, you can connect Power BI directly to that file within its Teams channel. This allows your dashboard to refresh automatically whenever the file is updated, saving you from having to re-upload it constantly.

Step-by-Step Instructions

1. Get the SharePoint Site URL Just like with the SharePoint List method, you first need the URL of the underlying SharePoint site. Go to the channel and the Files tab, click the three dots, and select Open in SharePoint. Copy the root site URL.
2. Use the SharePoint Folder Connector Open Power BI Desktop. Go to Get Data > More... and search for the SharePoint folder connector. Click Connect.
3. Enter the URL and Transform the Data Paste the SharePoint site URL you copied. A list of all files in that SharePoint document library - including everything from all channels in that Team - will appear. Click Transform Data to open the Power Query Editor.
4. Filter to Your File and Combine In the Power Query Editor window, use the filter on the "Folder Path" or "Name" column to find the specific Excel or CSV file you want to analyze. Once you have located the row with your file, click the Combine Files icon (a double-down arrow) in the header of the "Content" column. Power BI will automatically read the file, and you can then proceed to clean and model your data as needed before loading it into your report.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Best Practices for Your Teams Reporting

• Keep It Relevant: Don't try to visualize everything. Focus on the metrics that matter most to your team's goals, like engagement in project-specific channels or completion rates from a task list.
• Set Up Scheduled Refresh: After publishing your report to the Power BI Service, be sure to configure a scheduled refresh. This keeps your dashboard up-to-date with the latest data from Teams automatically - whether daily or hourly.
• Consider Privacy: Data from Teams can be sensitive. Be mindful of who you give access to your reports. Use Power BI workspaces to securely share dashboards with only the intended audience.
• Start Simple: Begin with the "Microsoft 365 Usage Analytics" app. It's a fantastic foundation. Once you see what’s possible, you can build on it by connecting to more specific lists or files related to your unique projects and workflows.

Final Thoughts

Connecting Microsoft Teams data to Power BI bridges the gap between daily collaboration and strategic insight. By using methods like template apps or direct connections to SharePoint, you can transform channel activity, task lists, and shared files into dynamic, easy-to-understand reports that help your team work smarter.

While setting up these connections in Power BI can be incredibly powerful, sometimes the initial steps of navigating different data connectors can feel like a chore. At Graphed , we created a way to connect all your business tools and build dashboards without the manual setup. Instead of clicking through menus, you just ask questions in plain English - like "Show me a chart of user activity in our project team this month" - and get a finished, professional dashboard in seconds. It allows you to skip straight to the insights.