Power BI in PowerPoint: Embed, Sync, and Automate Dashboards

Yes, there is an official Microsoft Power BI add-in for PowerPoint, and it does one thing well: it embeds a live, interactive Power BI report directly into a slide, so the numbers on screen are the current numbers instead of a screenshot from last week. You add it from the PowerPoint Insert menu, paste a report URL, sign in, and the visual renders inside the deck. What it does not do is generate slides for you, work without each viewer having Power BI access, or carry your branding. This guide covers how the official add-in works, where it stops, and when an enterprise team is better off with a custom build.

What is the Power BI PowerPoint add-in?

The Power BI add-in for PowerPoint is a free, Microsoft-built Office add-in that embeds a live Power BI report inside a PowerPoint slide. It came out of Microsoft's wider push to connect Power BI with the Microsoft 365 apps, and it installs from the same place as any other Office add-in, the Insert menu or AppSource.

Once it is in, you paste the URL of a report or a specific report page from the Power BI service. The slide then shows that visual, connected to the underlying dataset. In edit mode and in a slideshow, you can filter and cross-highlight the report the same way you would in Power BI itself, because it is the actual report rendered in place, not a picture of one. That is the whole point: a board deck or a quarterly review that reflects live data the moment you present it.

The add-in is aimed squarely at analysts and IT teams who already run Power BI and want their decks to stop going stale between the export and the meeting.

How to add the Power BI add-in to PowerPoint (step-by-step)

Installing the official add-in takes about a minute:

1. In PowerPoint, open the Insert tab and click Get Add-ins (the Office Add-ins store).
2. Search for Power BI, find the Microsoft-published add-in, and click Add, then accept the permissions prompt.
3. Back on the Insert tab, click the new Power BI button to drop an embed placeholder onto the current slide.
4. In the Power BI service, open the report you want, copy the URL of the report or the exact page, and paste it into the placeholder.
5. Sign in with the same Microsoft 365 account that has access to that Power BI workspace. The live visual renders in the slide.

How embedded Power BI reports work in PowerPoint

The embed is a live connection, not an export. When the slide loads and you are signed in with an account that has permission, the add-in queries the dataset and draws the current visual. Filters and slicers stay interactive, so during a presentation you can drill into a region or a quarter without leaving PowerPoint.

A few behaviours matter for anyone planning a real deck:

• Live versus snapshot. You can keep the visual live, or replace it with a static image snapshot for a fixed point in time. Snapshots are what you fall back to when the audience will not be signed in or online.
• Permission inheritance. The embed respects Power BI permissions. A viewer sees live data only if their account has access to that report and an appropriate Power BI license. Row-level security carries through, so people see the slices they are entitled to and nothing more.
• Presenter versus audience. In a live presentation the data refreshes for those who can reach the report. Anyone without access, or anyone offline, sees the snapshot or a prompt to request access rather than the live figures.
• Tenant boundaries. Because permissions follow the Power BI tenant, sharing a live deck across organisations is awkward. External viewers need guest access to your tenant, which IT in regulated UK and German enterprises will often refuse on data-residency grounds.

What you can do with live Power BI in PowerPoint

Used well, the official add-in covers a real set of recurring meetings:

• Monthly board decks where the KPI slide shows the current month live, instead of a number someone retyped the night before.
• Sales QBRs where reps filter a pipeline visual by territory in the room, answering questions from the data rather than promising a follow-up.
• Executive briefings that pull a single source of truth into the narrative, so finance and operations stop arguing about whose figure is right.
• Training and demo decks that point at a sandbox workspace, letting you show a working dashboard without exposing production data.

For finance teams in particular, this pairs naturally with the kind of reporting automation we describe in our case study on Excel add-ins for finance and accounting, where the same live-data principle removes the month-end copy-paste entirely. When the data sits in Power BI and needs to reach more than one Office app, our Power BI integration work builds the connector layer underneath.

Limits of the official Power BI PowerPoint add-in

This is where most enterprise teams hit a wall. The official Power BI add-in for PowerPoint is a viewer, not a production system, and the constraints are real:

• Every viewer needs Power BI access. No license or no permission means no live data. For a deck that leaves the building, that is a hard limit.
• No true offline mode. Without a connection, the live visual drops to a static snapshot. Presenters on a plane or a locked-down client site lose interactivity.
• Styling is tied to the report. The slide inherits the Power BI report theme. You cannot restyle the visual to match the deck without changing the report itself.
• No automated slide generation. The add-in shows a report; it does not build slides. Nothing updates your narrative slides when the underlying data shifts.
• No branding or white-label. You cannot ship a branded, client-facing version. It is the Microsoft add-in, as is.
• No cross-workflow reach. It does not touch Outlook, Teams, or an Excel model, and it has no multi-tenant or product distribution story.

None of this is a defect. It is the edge of what a free, general-purpose viewer is designed to do. Cross that edge and you are looking at a custom build.

When to build a custom PowerPoint add-in for Power BI scenarios

A custom add-in earns its cost when the recurring work is the deck itself, not just viewing one report. The scenarios we are asked for most:

• Scheduled deck generation. Build the full briefing deck automatically each night from Power BI data, so it is waiting in the inbox before the morning meeting.
• White-label delivery. Consulting firms and agencies that hand dashboards to clients need their own branding and distribution, not the Microsoft add-in. Publishing that through AppSource is something our AppSource publishing service handles end to end.
• Multi-source briefings. Combine Power BI figures with SAP and CRM data into one branded executive deck, blended before it ever reaches a slide.
• Custom interactivity. Controls, comparisons, and annotations the native viewer does not offer.
• Compliance and audit logging. Record who opened which dashboard and when, a requirement for finance and healthcare clients under GDPR in the UK and EU or HIPAA in the US.
• External distribution. Deliver live or refreshed decks to client organisations without forcing guest access into your tenant.

This is the point where our PowerPoint add-in development team gets involved, usually alongside the Power BI integration connector that feeds it.

How a custom PowerPoint + Power BI integration works

A custom build is a web app running inside PowerPoint. The stack is familiar to anyone who has shipped an Office add-in:

• Office.js PowerPoint API for the task pane and for creating and styling slides, shapes, and content controls in the deck.
• Power BI REST API (and the XMLA endpoint for direct dataset queries) to read report metadata, run queries, and export rendered visuals. Wiring that up cleanly is what our API integration work covers, including the Azure AD authentication flow.
• Microsoft Graph for the file and content automation around the deck, generating or updating presentations on a schedule rather than only in the app. Our Microsoft Graph API work handles that layer.
• Azure for hosting the add-in and any scheduled jobs that build decks unattended.
• Optional AI. Summarise a report's movement into plain-language slide bullets or speaker notes, which is exactly what our AI-powered Office add-in builds do on top of the data.

Here is the shape of the in-app side, inserting a generated insight slide with the PowerPoint API:

await PowerPoint.run(async (context) => {
  const slides = context.presentation.slides;
  slides.add();
  await context.sync();

  const summary = await fetch("/api/insights/latest").then((r) => r.json());
  const slide = slides.getItemAt(slides.items.length - 1);
  slide.shapes.addTextBox(summary.headline);
  await context.sync();
});

The data fetch, the AI summary, and the Power BI query all happen behind that endpoint, so the add-in stays responsive while the heavy work runs server-side.

Power BI dashboard automation: from manual to scheduled

Not every team needs a custom build. Match the effort to how often the work repeats:

1. Manual embed. A one-off or monthly deck where someone pastes a report URL by hand. The official add-in is the right tool. Do not over-engineer this.
2. Assisted generation. The deck structure is stable but the data changes often. A lightweight custom task pane can rebuild the data slides on demand while a human owns the narrative.
3. Full automation. A recurring, high-stakes deck, a nightly board pack or a weekly client report, generated unattended from Power BI plus other sources and delivered automatically. This is where a custom PowerPoint add-in plus a scheduled pipeline pays for itself.

A useful test: if a person spends more than an hour a week rebuilding the same deck from a dashboard, automation usually returns that hour many times over. We have delivered 250+ projects over 5+ years for 100+ clients at a 98% satisfaction rate, and dashboard-to-deck automation is one of the clearest wins in that work. For the analytics groundwork that often precedes it, our guide to data analysis tools in Excel is a useful companion read.

Frequently asked questions

Is the Power BI add-in for PowerPoint free?

Yes. The official Microsoft add-in installs at no cost from the Office Add-ins store. What is not free is the data: viewing a live report still requires each person to have access to that Power BI content and an appropriate Power BI license. The add-in is free; the underlying Power BI access is not.

Do my audience members need a Power BI license to see embedded reports?

To see live data, yes. Each viewer needs permission to the report and a suitable Power BI license, because the embed honours Power BI security, including row-level security. Viewers without access see a static snapshot or a request-access prompt instead of the live visual.

Can I embed Power BI reports in PowerPoint for the web?

The add-in is an Office add-in, so it runs in PowerPoint on the desktop and on the web where add-ins are supported. The live data still depends on being signed in with an account that has access to the report. Behaviour can vary slightly between platforms, so test where your team actually presents.

Does the Power BI add-in work offline?

Not for live data. A live embed needs a connection to query the dataset. For offline presenting, replace the live visual with a static image snapshot before you disconnect, so the slide still shows the figures even though it is no longer interactive.

Can I automate generating PowerPoint slides from Power BI?

Not with the official add-in, which only displays a report. Automated slide generation, building or refreshing a deck from report data on a schedule, needs a custom add-in using the Office.js PowerPoint API, the Power BI REST API, and Microsoft Graph. That is a development project, not a setting.

How long does it take to build a custom Power BI add-in for PowerPoint?

It depends on scope. A focused task pane add-in that embeds and styles reports starts in a few weeks. Full automation, scheduled multi-source deck generation with branding and compliance logging, runs into months. Tell us your scenario and we will scope an accurate estimate.

Build a custom Power BI PowerPoint add-in

When the official viewer stops short of what your team needs, automated decks, branding, external delivery, or compliance logging, a purpose-built tool closes the gap. Our PowerPoint add-in development team builds these on Office.js, fed by the Power BI integration connector that handles the data.

Want to figure out whether the free add-in is enough or you need a custom build? Talk to a Power BI integration developer on a free scoping call, and we will help you map the fastest route to decks that update themselves.