How to Export Graph from Power BI
Sending a chart from Power BI to a presentation slide or an email shouldn't be complicated, yet the options can be confusing. Whether you need a simple image, a full PDF report, or just the raw numbers behind the graph, there’s a specific method that works best for each case. This tutorial will walk you through the most common and effective ways to export your visuals from Power BI, ensuring your insights reach your audience clearly and efficiently.
Why Would You Need to Export a Graph from Power BI?
While Power BI is fantastic for interactive, live data exploration, there are many practical reasons to pull a graph out of the dashboard environment. Most of them revolve around sharing insights with people who may not be in Power BI at that moment.
Common scenarios include:
- Presentations: Dropping a key performance chart onto a PowerPoint or Google Slides presentation to support your team meeting or client pitch.
- Formal Reports: Embedding visualizations into a Word document, Google Doc, or PDF for a quarterly review or a project summary.
- Email Communications: Quickly sharing a specific visual to highlight a trend or answer a coworker's question directly in an email thread.
- Offline Analysis: Exporting the data behind the graph to Excel so you can perform ad-hoc calculations, build a custom model, or merge it with another dataset.
Knowing which export method to use will save you time and help you communicate your data story more effectively.
Method 1: Copy a Visual as a Static Image
This is the fastest way to grab a single chart and paste it somewhere else. It’s perfect for emails, chat messages, or dropping a quick visual into a document without fuss. The output is a simple, static image (like a PNG).
Step-by-Step Instructions
- Open your Report: Navigate to the Power BI report (in either Power BI Desktop or the Power BI Service) containing the visual you want to export.
- Hover Over the Visual: Move your mouse cursor over the chart you want to copy. A small set of icons will appear in the top-right corner of the visual's container.
- Select 'Copy visual as image': Look for the icon that looks like a clipboard or a chart being copied. Clicking this will open the "Copy visual as image" dialog box. Alternatively, you can click the ellipsis (...) menu in the same corner and select "Copy visual as image" from the dropdown.
- Choose Your Options: A pop-up will give you a couple of choices:
- Paste Your Image: Once you click copy, the image is on your clipboard. You can now go to your other application (PowerPoint, Word, Outlook, Teams, etc.) and paste it using Ctrl+V (or Cmd+V on Mac).
Pros and Cons of This Method
- Ideal For: Quick, informal sharing where interactivity isn't needed. Perfect for answering one-off questions visually.
- Pros:
- Cons:
Method 2: Export an Entire Report Page to PDF or PowerPoint
When you need to share a whole dashboard page - or even an entire multi-page report - exporting it as a file is the way to go. This method captures the full context of your report page and is ideal for formal presentations and offline distribution.
Note: This functionality is most robust in the Power BI Service (the web-based version).
Step-by-Step Instructions
- Open Your Report in Power BI Service: Log in to your Power BI account at app.powerbi.com and open the designated report.
- Go to the Export Menu: In the top navigation bar, click on File > Export. This will reveal several options for exporting your report.
- Choose Your Format: PDF or PowerPoint
Option A: Exporting to PDF
This creates a high-quality, non-editable document perfect for printing or digital distribution.
- Select PDF from the export menu.
- An options dialog will appear. Here you can configure your export:
- Click Export. Power BI will then process the report and make the PDF file available for you to download. This might take a minute or two for large reports.
Option B: Exporting to PowerPoint
This is a powerful feature for anyone who builds presentation decks. It allows you to embed your report pages directly into slides.
- Select PowerPoint from the export menu.
- In the options dialog, you'll see a crucial choice:
- Click Export. Like the PDF export, it will take a moment to generate the
.pptxfile for download. Each selected report page will be converted into its own slide.
Method 3: Export the Data Behind the Graph
Sometimes you don’t want the picture of the graph, you want the numbers that built it. Power BI allows you to export the underlying or summarized data directly from any visual into an Excel (.xlsx) or .csv file. This is your go-to method for when you want to run your own analysis, spot-check figures, or use the data in another tool.
Step-by-Step Instructions
- Navigate to Your Visual: Open the report and find the chart whose data you need.
- Open the Ellipsis Menu: Click the three dots (...) in the top-right corner of the visual.
- Select "Export data": This will open the core data export dialog.
- Choose Your Data Format: This is the most important step. You will see several options:
- Click Export. Power BI will generate the file based on your choice and start the download.
Important Notes on Exporting Data:
- Row Limits: Power BI limits how many rows you can export. For Pro users, typically 30,000 rows for
.csvand 150,000 for.xlsx. Premium users have higher limits. - Admin Controls: Your Power BI administrator may disable data export features for governance/security reasons.
Bonus Tips for High-Quality Exports
Follow these quick best practices to make your exported visuals as effective as possible.
- Check Your Filters First: The export will capture the data in its current state, including filters and slicers. Double-check before exporting.
- Use Descriptive Titles: Change chart titles to be more detailed if needed (e.g., "Monthly Sales Trend Q3 2023 - NA") for clarity in static reports.
- Optimize for the Destination Format: Design report pages with the target medium in mind. Use Power BI "Canvas settings" like "16:9" for presentations.
- Consider Accessibility: Use high-contrast themes, clear fonts, and labels so data is understandable when exported as images.
Final Thoughts
With these three methods, you can confidently move your insights from Power BI into any format you need—whether it’s a quick image for an email, a PDF report, or the raw data for detailed analysis. Each serves different purposes, and mastering them will make your data storytelling more precise and impactful.
Instead of manually exporting reports and dealing with static, out-of-date data, creating live dashboards is often simpler. At Graphed, we help you connect all your data sources and generate real-time reports with natural language commands — giving your team constant access to fresh data without exporting screenshots or CSVs, turning hours of manual work into a 30-second task.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.