How to Send Power BI Report in Email

Sending a Power BI report in an email might seem like a simple task, but it’s a crucial one for keeping your team and stakeholders in the loop. Whether you need to send a daily sales summary to executives or a weekly performance snapshot to your team, automating this process saves time and ensures everyone has the latest information. This article will show you the most effective ways to email your Power BI reports, from simple subscriptions to more advanced, customized automation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Email Power BI Reports?

Before jumping into the "how," it's helpful to understand the "why." While the beauty of Power BI lies in its interactive dashboards, not everyone on your team has the time (or the license) to log in and explore the data themselves. Emailing reports serves a few key purposes:

• Accessibility: It pushes key insights directly to stakeholders' inboxes, meeting them where they already work.
• Consistency: Scheduled reports create a consistent rhythm for data review within the organization, such as a "Monday Morning Metrics" email.
• Record Keeping: Emailed reports can serve as a static snapshot of performance at a specific point in time, which can be useful for historical comparison.
• Driving Action: By delivering timely data, you prompt teams to discuss performance, spot trends, and make faster decisions.

Method 1: Using Power BI Subscriptions (The Standard Way)

The most straightforward method to email a report is by using the built-in "Subscribe" feature in the Power BI service. This is ideal for regular, recurring snapshot reports you want to send to yourself or colleagues within your organization.

Note: You'll need a Power BI Pro or Premium Per User (PPU) license to create subscriptions. Recipients also need a Pro or PPU license unless the report is in a workspace backed by a Premium capacity.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Creating a Subscription

Follow these steps to set up your first email subscription:

1. Open Your Report in the Power BI Service

Navigate to the Power BI Service (app.powerbi.com) and open the report you wish to email. This feature is not available in Power BI Desktop.

2. Click the "Subscribe" Button

In the top menu bar of the report, you'll see a button labeled Subscribe. Click on it. If you don't see this, you may not have the necessary permissions or license.

3. Create a New Subscription

A pane will open on the right side of your screen. Click + Add new subscription. If you have existing subscriptions for this report, they will be listed here, and you can edit them by clicking the pencil icon.

4. Configure the Subscription Settings

This is where you define who gets the email, what it contains, and how often it's sent.

• Name: Give your subscription a descriptive name, like "Daily Sales Digest" or "Monthly Marketing KPI Report."
• Subscribers: Type the names or email addresses of the people in your organization you want to receive the email. Your name is added by default.
• Subject & Optional Message: The subject line of the email will default to the report name, but you can customize it completely. Add a brief message to give recipients context about the report.
• Content: Choose whether to attach a full report or just a preview image in the email. You can select PDF or PowerPoint (PPTX) as the attachment format.
• Report Page: By default, it will be the page you were viewing when you clicked "Subscribe." You can select a different page from the dropdown if you only want to send a specific view.
• Schedule / Frequency: This is the core of the automation. You can set the email to be sent Daily, Weekly, Monthly, or even Hourly. You can also select the scheduled time and time zone. A very useful option is After data refresh, which ensures the email only goes out after your dataset has been updated with the latest data.

5. Set Advanced Options and Save

Toward the bottom, you have a couple of powerful options:

• Permission to view the report in Power BI: If checked, this grants recipients permission to open and view the live interactive report. If unchecked, they'll only get the static emailed version.
• Link to report in Power BI: Includes a direct button in the email that takes users to the live report.
• Report Preview Image: Includes a visual snapshot of the report directly in the email body, which is great for a quick glance.

Once you’re happy with the settings, click Save and close. Your subscription is now active!

Method 2: Using Power Automate (For Advanced Control and Flexibility)

What if you need more than the standard subscription offers? Maybe you want to send the report to external users, use custom recipients based on the data, or export it in a different format. This is where Power Automate comes in.

Power Automate (formerly Microsoft Flow) lets you create automated workflows between your favorite apps and services. It integrates tightly with Power BI, giving you a ton of flexibility.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When to Use Power Automate Instead of a Standard Subscription:

• You need to email a report to external users who are not part of your organization.
• You want to dynamically determine the recipients (e.g., email a regional manager only their region's report).
• You need to send the report based on a specific data alert (e.g., "Email the team if sales drop below $10,000").
• You want to save the exported report to SharePoint, OneDrive, or Teams in addition to emailing it.
• You need more advanced scheduling options than what's available in the built-in feature.

A Basic Power Automate Flow to Email a Report

Creating a Power Automate flow takes a few more steps, but it unlocks serious potential. Here’s a high-level overview of how you’d build a simple scheduled flow.

1. The Trigger

Every flow starts with a trigger. For an emailed report, a common choice is the Schedule trigger (e.g., Recurrence). You can configure it to run at any interval you need - every day, every Monday at 8 AM, etc. Another powerful trigger is the Power BI trigger When a data driven alert is triggered.

2. The Action - Export to File

The key action for this process is found under the Power BI connector: Export To File for Power BI Reports. This action is the workhorse of your flow. You'll need to specify:

• Workspace: The Power BI workspace where your report lives.
• Report: The specific report you want to export.
• Export Format: Choose from PDF, PPTX (PowerPoint), or PNG.

3. The Action - Send Email

After the report is exported "in the cloud," you need to email it. Add an action using the Outlook Send an email (V2) connector or the Gmail connector. In this action, you will:

• To: Define the recipients' email addresses. This can be a static list or dynamic content from an earlier step.
• Subject & Body: Craft your email subject and body text, just like with a standard subscription.
• Attachments: This is the key step. In the Attachments section, you will add the File Content and File Name from the dynamic output of your "Export To File" action. This attaches the generated PDF or PowerPoint file to your email.

Once you save and run the flow, Power Automate will handle the entire process for you on the schedule you defined. You can build on this by adding conditions, fetching a list of email recipients from a SharePoint list, and much more.

Method 3: Simply Sharing a Link

Sometimes, all you need to do is give someone the ability to view the live report. This doesn’t send a static snapshot but rather provides direct access to the interactive version. You can embed this link in an email, a Teams message, or on a SharePoint site.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Share a Report Link by Email

1. Open the report in the Power BI Service.
2. Click the Share button in the top menu.
3. In the "Send link" dialog, enter the names or email addresses of your colleagues.
4. Adjust the permissions settings (e.g., allow them to re-share or build content with the underlying data).
5. Check the "Send an email notification to recipients" box.
6. Click Send.

Your recipients will receive an email with your message and a direct button to "Open this report." This is the best option when you want your audience to explore, filter, and interact with the data themselves, rather than just consume a static image.

Choosing the Right Method

With several options available, which one should you choose? Here's a quick cheat sheet:

• For simple, recurring internal reports where a snapshot is sufficient, use the built-in Subscriptions. It's fast, easy, and requires no extra tools.
• For complex scenarios, external sharing, or conditional alerting, use Power Automate. It has a steeper learning curve but offers almost limitless flexibility.
• When you want colleagues to interact with the live, filterable report, use the Share button to email a direct link.

Final Thoughts

In short, Power BI provides multiple ways to get reports into your team’s hands via email. Standard subscriptions are perfect for simple and regular updates, Power Automate offers unparalleled control for custom workflows, and sharing a direct link is ideal for collaborative, interactive use. Selecting the right approach depends entirely on who your audience is and what you need them to do with the data.

The real goal of reporting isn't just sending emails, it's about making business insights accessible and effortless for a team to act on. At Graphed, we streamline this process by removing the technical hurdles altogether. Instead of wrestling with complex configurations or filtering through dense reports, your entire team can build and share real-time dashboards simply by asking questions in plain English. This means you spend less time managing reporting workflows and more time making data-driven decisions.