Power BI Controller add-in automation is a game-changer for anyone embedding live Power BI reports into PowerPoint presentations. If you’ve ever spent hours manually updating slides each time your report changes, Microsoft has just made your life a whole lot easier.
With the new Power BI Controller for PowerPoint, you can manage all your embedded report pages in one centralized pane enabling bulk updates, reconnections, and global settings changes in just a few clicks.
What Is the Power BI Controller Add-In?
The Power BI Controller is a task pane add-in for PowerPoint that:
- Detects all embedded Power BI report pages in your presentation
- Allows you to refresh or reconnect all report pages at once
- Applies configuration changes across multiple slides
- Eliminates the need to go slide-by-slide to manage your reports
This is especially useful for data-driven presentations where content updates frequently daily, weekly, or even hourly.
How to Enable the Power BI Add-in in Your Tenant
Before you begin, make sure your organization has enabled the add-in:
- Go to the Power BI Admin Portal
- Search for “PowerPoint” in the search bar
- Under Tenant Settings > Export and sharing settings, enable Power BI add-in for PowerPoint
If disabled, this feature won’t work. Contact your IT admin to request access.
Embedding Power BI Report Pages into PowerPoint
You can embed a report page in two ways:
Option 1: From Power BI Service
- Open your report in PowerBI.com
- Go to Export > PowerPoint
- Select Embed live data for interactivity
- Click Copy Link
Paste this into your PowerPoint using the Power BI add-in.
Option 2: Directly in PowerPoint
- Open Add-ins in PowerPoint
- Search for Power BI
- Insert the standard Power BI add-in
- Choose your report and select the specific page
Tip: Choose live data for interactive dashboards, or embed as image for a static snapshot.
Managing Permissions: Who Can View Embedded Reports?
Remember that the embedded Power BI content reflects your access level. If you share your deck with someone who doesn’t have access to the report:
- They won’t see the data
- You can choose to grant automatic access when embedding
This ensures the right people see the right data.
Resize and Customize Your Embedded Reports
Once embedded, the report behaves like a live visual inside PowerPoint:
- Resize the frame to fill the slide or share space with other visuals
- Click through visuals filters, slicers, and drill-through actions work as expected
- Use multiple pages from multiple reports across your presentation
Introducing the Power BI Controller Add-In (The Real Game-Changer)
The Power BI Controller is the second add-in you need to activate. You’ll recognize it by the gear icon next to the Power BI logo in the Add-ins menu.
What It Does:
- Scans the entire presentation to detect all embedded Power BI visuals
- Lists them in a central task pane
- Allows you to refresh, reconnect, or reset all embedded visuals
- Applies configuration changes across multiple slides at once
Perfect for when you have many embedded pages and don’t want to update each one manually.
Key Features of the Power BI Controller Pane
Once installed and activated:
- It auto-discovers all Power BI add-ins in your deck
- You can apply settings to sync with Power BI view or restore defaults
- Easily reconnect visuals that lost authentication
- See last refresh times and get alerts if the data is outdated
Save time managing embedded data without editing each slide!
Limitations and Considerations
- The Power BI Controller is still in preview (as of October)
- Large decks with many report pages may slow performance
- Both add-ins (standard + controller) must be installed for full functionality
Final Thoughts: A Must-Have for Data-Driven PowerPoint Users
If you’re embedding Power BI report pages into PowerPoint decks especially for executive dashboards, board reviews, or recurring reports the Power BI Controller add-in is essential.
It centralizes your report maintenance, saves hours of manual updates, and improves consistency across your presentation.
Learn More and Keep Growing
Explore more Power BI automation and visualization tips in our Power BI Training courses.
