How to Use Power BI in Microsoft Teams

Constantly switching between your Power BI dashboard and your Microsoft Teams chats is the fastest way to lose your train of thought. You find an insight, take a screenshot, paste it into a channel, and type out the context - by then, the moment is gone and the conversation has moved on. There's a much better way. This article will show you exactly how to integrate Power BI directly into Microsoft Teams, turning your channels into collaborative, data-driven workspaces.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Integrate Power BI with Microsoft Teams?

Before we get into the "how," let's quickly cover the "why." Connecting these two powerful Microsoft tools isn't just a matter of convenience, it’s about changing how your team interacts with data. When you embed live, interactive reports directly where your team is already collaborating, you remove the friction that prevents people from using data in their daily decisions.

• Centralized Data Hub: Stop making your team hunt for the right link or navigate a complex folder structure. Placing a report in the relevant team channel makes it the single source of truth for that project or department.
• Data in Context: Conversations happen right alongside the data. Instead of talking about an abstract chart from a week-old email, you can discuss live metrics and drill down into the report together to answer follow-up questions in real-time.
• Faster, Smarter Decisions: When data is easily accessible and part of the daily workflow, teams become more data-literate. This seamless access empowers everyone, from sales reps to project managers, to make informed choices without waiting for a data analyst to run a report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Start: What You'll Need

To make this process as smooth as possible, make sure you have a few things in order first. This will save you from hitting any roadblocks later on.

• The Right Licenses: Everyone who needs to view the embedded reports will need a Power BI Pro or Premium Per User (PPU) license. To share the reports, you'll also need a corresponding Microsoft 365 license that includes Microsoft Teams.
• Appropriate Permissions: Users need permission to view the report in Power BI itself. Simply adding a report to a Teams channel doesn't override the underlying Power BI security settings. Ensure the people in your team have access to the report or the workspace it's published in.
• A Published Report: You need an existing report published to the Power BI service (app.powerbi.com). You can’t embed a report directly from the Power BI Desktop application.

Sharing Power BI Reports in Teams: Step-by-Step

There are several ways to bring your data into Teams, each suited for a different purpose - from creating a permanent dashboard for a channel to quickly sharing an interesting chart in a one-on-one chat.

Method 1: Adding a Power BI Tab to a Team Channel

This is the most common and effective method for making a report a central part of a team's workspace. It pins an interactive report as a permanent tab at the top of a channel.

1. Navigate to Your Channel: Open Microsoft Teams and go to the team and specific channel where you want to add the report.
2. Add a New Tab: At the top of the channel, next to "Posts," "Files," and "Wiki," click the plus (+) icon to add a new tab.
3. Select Power BI: A window will pop up with a list of apps. Search for Power BI and click on it. You may need to click "Add" if it's the first time you've used the integration.
4. Choose Your Report: Power BI will display a list of your available workspaces and reports. Navigate to the report you want to embed and select it. You can also paste a direct link to a report if you have it handy.
5. Save the Tab: Once you've selected your report, click "Save." Your interactive Power BI report will now appear as a new tab in the channel. Team members can open it, apply filters, and interact with the visuals just as they would in the Power BI service.

Pro Tip: When you save the tab, there's a checkbox labeled "Post to the channel about this tab." Keep this checked to automatically create a post that notifies everyone in the channel that a new report is available.

Method 2: Pasting a Report Link into a Conversation

Need to share a report on the fly during a discussion? All you need is the link. When you paste a link to a Power BI report into a Teams chat or channel, Teams automatically unfurls it into an interactive card.

1. Get the Report Link: Go to the Power BI service, open the report you want to share, and copy the URL from your browser's address bar.
2. Paste it in Teams: Go back to your Teams conversation and simply paste the link into the message box.
3. Let Teams Do the Work: Teams will automatically generate a preview card of the report. The card includes the report's title, key information, and a button to "Open" it. This provides more context than a simple, unformatted URL.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Using the "Chat in Teams" Feature from Power BI

Sometimes you start in Power BI and an insight prompts you to start a discussion. Instead of switching apps, you can initiate a Teams conversation directly from your report.

1. Open a Report in Power BI: Log in to the Power BI service and open the dashboard or report that you want to discuss.
2. Click "Chat in Teams": In the top action bar of the report, you'll see a button labeled "Chat in Teams." Click it.
3. Choose Your Destination: A dialog box will appear. You can type the name of a person, group chat, or channel to share the report with. You can also add a message to provide context for what you're sharing.
4. Hit Share: Once you click "Share," Power BI will send the message and a link to the report directly to the Teams conversation you specified. This is perfect for pointing out a specific, timely trend and getting immediate feedback.

Beyond Sharing: Collaborating with Your Data

The real power of this integration comes from what you do after the report is shared. It transforms BI from a one-way broadcast into a two-way conversation.

Working with Your Report Tabs

Once you have a Power BI tab in your channel, you can make it a true collaborative hub:

• Start Conversations: To the top right of the report tab, you'll find a small conversation bubble icon. Clicking this opens a dedicated chat panel alongside your report, allowing the team to discuss the data without ever leaving the view. New comments here will also show up as replies to the original notification post in the main channel feed.
• Go Full-Screen: Click the diagonal arrows icon to expand the report to fill your entire screen, which is great for presentations during team meetings.
• Refresh Data: The tab is a live-embedded view. Use the refresh button to ensure you're looking at the most current data, just like you would in Power BI online.

Using the Personal Power BI App for Teams

If you work extensively with Power BI, the personal app is a game-changer. It essentially brings the entire Power BI service experience into your Teams sidebar, so you don't have to keep a browser tab open.

To add it, click the three-dots icon (...) in your Teams sidebar, search for Power BI, and add it. Once pinned, you can:

• Access all your workspaces, reports, apps, and dashboards.
• Use the "Create" hub to start building reports from existing datasets.
• View your "Home" feed with favorited and frequently visited reports.
• Get notifications from Power BI directly within your Teams activity feed.

This personal view consolidates your workflow, saving countless clicks and context switches throughout your day.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Integrating Power BI with Microsoft Teams transforms your dashboards from static artifacts into dynamic hubs for collaboration. By bringing data directly into the conversations where decisions are made, you empower your team to be more agile, informed, and effective.

While powerful tools like Power BI are fantastic for advanced analysis, the setup and learning curve can still be a challenge for teams just starting out. At Graphed, we focus on simplifying that first step - connecting your data and getting answers in seconds. Instead of navigating complex report builders, you can simply ask questions in plain English, like "Show me my top advertising channels by revenue last quarter," and instantly get the charts and reports you need. If you're looking for a faster way to analyze your marketing and sales data without the steep learning curve, you might find Graphed to be an incredibly helpful addition to your toolkit.