How to Add Export to PDF Button in Power BI

Sharing your Power BI reports should be simple, but sending someone a link often requires them to have a Power BI account and the right permissions. Creating a straightforward "Export to PDF" button directly within your dashboard gives you a powerful way to generate static, shareable snapshots of your data in a universally readable format. This article will walk you through two effective methods for adding a PDF export button to your Power BI reports, from a simple navigation trick to a fully automated solution.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Add a PDF Export Button in the First Place?

Before diving into the "how," let's quickly cover the "why." A dedicated export button enhances your Power BI reports in several practical ways:

• Accessibility: Not everyone in your organization, or every client, will have a Power BI license or know how to navigate the service. A PDF is a universal format that anyone can open and view on any device without special software.
• Static Snapshots: Live dashboards are fantastic for real-time analysis, but sometimes you need a point-in-time snapshot for a weekly report, an appendix in a document, or regulatory archiving. A PDF provides a static, unchangeable record of the data as it appeared at a specific moment.
• Easy Sharing: Attaching a PDF to an email or a message in Slack or Microsoft Teams is often faster and more direct than sharing links, explaining permissions, and guiding users through the Power BI service.
• Printing: PDFs are designed to be printed. An export button makes it incredibly easy for users to create a print-ready version of your report page without fussing over browser print settings.

Method 1: The Simple Bookmark-and-Button Trick

This first method is the quickest way to guide users to a specific, pre-filtered view of your report that's perfectly prepared for a manual PDF export. It doesn't automate the export, but it reduces the process to just two clicks for your user: one on your new button, and one on the built-in "Export to PDF" menu.

Think of it as creating a "ready for export" preset for your report page.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Get Your Report Page Ready

First, prepare the report page exactly as you'd want it to appear in the PDF. This is a crucial step that determines what the final output will look like.

• Apply any necessary filters in the Filters pane.
• Adjust any slicers to display the specific data cut you want to capture (e.g., "Last 30 Days," "North America Region," etc.).
• Change any drill-down levels or interaction states on your visuals.

Basically, you're setting the stage. What you see on the screen now is what the user will export.

Step 2: Create a Bookmark

Bookmarks in Power BI save the current state of a report page. This is the magic that allows us to "save" our filtered view.

1. Go to the View tab in the Power BI Desktop ribbon.
2. Click on the Bookmarks button to open the Bookmarks pane (if it isn't already open).
3. Click Add. A new bookmark will appear in the pane, likely named "Bookmark 1".
4. It's good practice to rename it to something descriptive. Double-click the name and change it to something like "PDF Export View" or "Q3 Summary State."
5. Important: Click the three dots (...) next to your new bookmark and make sure that "Data" is checked. This ensures your filter and slicer selections are saved with the bookmark. For this use case, you can usually uncheck "Display" and "Current Page."

Step 3: Insert and Format Your Button

Now, let's create a clickable element for the user.

1. Go to the Insert tab in the ribbon.
2. Click on Buttons and choose a shape. A blank button is often the most flexible.
3. Position the button somewhere logical on your report canvas, like the top corner.
4. With the button selected, use the Format pane to customize it.

Step 4: Link the Button to Your Bookmark

This is where we connect the action.

1. Select the button you just created.
2. In the Format pane, toggle the Action option to "On."
3. Expand the Action section.
4. For Type, select Bookmark.
5. For Bookmark, choose the "PDF Export View" bookmark you created in Step 2.

That's it! Now, in your report, a user can simply hold Ctrl + Click (in Desktop) or just click (in the Power BI Service) on the button. The report page will instantly revert to the exact filtered state you saved in the bookmark. From there, they just need to go to File > Export > Export to PDF to get their document.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: True Automation with a Power Automate Button

While the bookmark method is helpful, it’s not fully automated. If you want a one-click button that actually generates a PDF and delivers it to the user (e.g., via email or by saving to OneDrive), you need to level up with Power Automate. This method requires a Power BI Pro or Premium Per User license, as Power Automate integration is a premium feature.

Step 1: Add the Power Automate Visual to Your Report

This special visual is how you bridge the gap between your Power BI report and an automated workflow.

1. In Power BI Desktop, find the Visualizations pane.
2. Click the three dots (...) at the bottom and select Get more visuals.
3. Search for "Power Automate" and add the official visual developed by Microsoft to your report.
4. Once added, click the Power Automate icon in your Visualizations pane to add it to your report canvas.

Step 2: Configure the Power Automate Flow

This is where you'll build the automated workflow.

1. With the new visual selected on your canvas, drag any data field required for the flow into the "Power Automate data" field well. For a simple export, you could add a measure like [Total Sales] or any other field, it just needs one field to activate it.
2. In the visual, click the three dots (...) and select Edit.
3. This will open the Power Automate flow builder interface directly inside Power BI. Click New, then choose Instant cloud flow.
4. The trigger, "Power BI button clicked," will already be there. Click + New step to add the action.
5. Search for "Power BI" and select the action named "Export To File for Power BI Reports."

Step 3: Define the Export Action

You now need to tell Power Automate exactly what to export and how.

• Workspace: Select the Power BI workspace where the report is published.
• Report: Select the specific Power BI report you are working on.
• Export Format: Set this to PDF.
• Pages pageName - 1: Enter the name of the report page you want to export (e.g., 'Summary Page'). Pro-Tip: You can use the bookmark from Method 1 here! In the "Bookmark Name" field, you can enter the name of your bookmark to export that specific view.

Step 4: Decide What to Do with the File

After the PDF is generated, your flow needs to do something with it. A common choice is to email it to the user who clicked the button.

1. Click + New Step.
2. Search for "Send an email" and choose the "Send an email (V2)" action from the Office 365 Outlook connector.
3. In the To field, use dynamic content and select the "User's UPN" or "User's Email" from the Power BI button trigger. This ensures the email goes to the person who clicked the button.
4. Give the email a Subject, like "Your Requested Power BI Report Export."
5. Write some body text.
6. Finally, under Advanced options, give the attachment a name (e.g., "report-export.pdf") and in the Attachment Content field, select File Content from the dynamic content list, which pulls from your "Export To File" action.

Save your flow, and go back to your report. You can now resize the Power Automate button and format the button text. When a user clicks it, the flow will run in the background, generate the PDF, and email it to them. It's a completely seamless, one-click experience.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Key Considerations & Limitations

Before you roll this out, be aware of a few things:

• Export Limits: Power BI has limitations on how many exports can be run per hour per capacity. For most typical use cases on Pro, you get 50 exports per hour. This is generally more than enough, but it's something to be aware of for widely used reports.
• Visual Rendering: Not all visuals export perfectly to PDF. Most core and certified custom visuals work great, but some niche or uncertified visuals may not render correctly. Always test your export to ensure it looks right.
• Flow Runtimes: The Power Automate flow isn't instantaneous. It may take 30-60 seconds to generate the file and send the email, so you might want to add a note on the report to manage user expectations.

Final Thoughts

Whether you choose the simple bookmark method to prepare a view for manual export or the advanced Power Automate solution for true one-click automation, adding an export button makes your Power BI reports more user-friendly and accessible. It bridges the gap between interactive analysis and the need for static, shareable documents, empowering your team to get more value from your data.

While tools like Power BI are incredibly powerful, setting up and maintaining these kinds of workflows still involves manual steps inside a complex interface. At Graphed, we handle this differently by design. Instead of clicking through menus to build flows, you can just connect your data sources and use plain English to generate real-time dashboards automatically. We believe getting insights shouldn't require you to become an expert in a specific BI tool - it should be as simple as asking a question.