How to Schedule a Power BI Report to Email

Manually exporting and emailing Power BI reports is a tedious task that can quickly eat up your week. Automating this process saves you time and ensures your stakeholders consistently get the data they need, right on schedule. This tutorial walks you through exactly how to set up, manage, and even customize email subscriptions for your Power BI reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Schedule Reports via Email?

Setting up an email subscription does more than just save you a few clicks. It creates a reliable and automated channel for data distribution that has several key benefits:

• Time-Saving Automation: The most obvious benefit is reclaiming your time. Instead of remembering to go into Power BI, export a PDF, attach it to an email, and send it out every Monday morning, you can set it up once and forget it. This frees you up to focus on analyzing data, not distributing it.
• Consistent Communication: When an executive team expects a sales summary every Friday, automation ensures it arrives on time, every time. It removes the risk of human error - like forgetting to send the report or sending it to the wrong person - and establishes a predictable reporting cadence your team can rely on.
• Keeping Stakeholders Informed: Not everyone on your team has the time or inclination to log in to Power BI and explore dashboards. Emailing a snapshot of a critical report as a PDF or an image ensures that key metrics and insights are pushed directly to them in a format they can easily view and understand.
• Improved Data Adoption: By delivering key insights directly to people's inboxes, you make it easier for them to engage with company data. This simple act of pushing reports out can help build a more data-driven culture because it removes the friction of having to proactively seek out the information.

Prerequisites: What You Need First

Before you can start scheduling reports, you need to have a few things in place. If the "Subscribe" option is greyed out or you're running into issues, it's likely because one of these requirements isn't met.

• A Power BI Pro or Premium Per User (PPU) License: Creating email subscriptions is considered a Pro feature. Users with a free Power BI license can receive email subscriptions, but they cannot create them. Your administrator can confirm your license type.
• Report Published to a Workspace: The report you want to schedule must be published to a workspace, not your personal "My workspace." Subscriptions are tied to these collaborative environments.
• The Right Permissions: At a minimum, you need a Viewer role in the workspace to subscribe yourself to a report. If you want to create subscriptions for other people, you’ll need a Contributor, Member, or Admin role.
• A Configured Data Refresh Schedule: An email subscription sends a snapshot of the report at a specific time. If your underlying dataset hasn't been refreshed, you'll be emailing stale data. Ensure your dataset is scheduled to refresh automatically before your email subscription is set to run.

Step-by-Step: Creating a Power BI Email Subscription

Once you’ve met the prerequisites, setting up a subscription is a straightforward process within the Power BI Service. Just follow these steps.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Navigate to Your Report and Click Subscribe

First, log in to the Power BI Service (app.powerbi.com) and navigate to the workspace containing the report you want to schedule. Open the report. In the toolbar at the top of the report, you will see a 'Subscribe' button with an envelope icon. Click on it.

2. Add a New Subscription

A pane will open on the right side of your screen. If this is the first subscription for this report, it will be empty. Click the + Add new subscription button to begin configuring your scheduled email.

3. Configure the Subscription Settings

This is where you'll define who gets the report, when they get it, and in what format. Let's break down each option:

• Subscribers: In the 'Subscribe' field, Power BI will automatically add your email. You can add more people by typing their email addresses. You can also add entire Microsoft 365 groups to subscribe a whole team at once. You can have up to 24 subscriptions per report, with each subscription having multiple recipients.
• Subject & Message: Customize the email subject line and add an optional message. Best practice is to make the subject clear and informative, like "Weekly Sales Performance Summary" so recipients immediately know what the email contains. The message can provide brief context or highlight what they should pay attention to.
• Report Page: By default, it’s set to the page you were viewing when you clicked 'Subscribe.' If you want to send a different page, you can choose it from the dropdown. Important: a single subscription can only send one report page. If you need to send multiple pages from the same report, you’ll need to set up a separate subscription for each page.
• Frequency: This is the core of scheduling. You have several options:
• Schedule and Time Zone: Select your desired delivery time and ensure the time zone is set correctly for when you want recipients to get the email.
• Start and End Dates: Optionally, you can set a date for the subscription to start and a date for it to end. This is useful for project-based reports that are only relevant for a certain period.
• Attachment Format: Choose what you want to attach to the email:
• Final Options:

4. Save and Test Your Subscription

After you’ve configured everything, click Save and close at the bottom of the pane. Your subscription is now active. To test if it works as expected without waiting for the next scheduled time, you can go back into the subscription settings and click Run now. This will send the email immediately.

Managing and Troubleshooting Your Subscriptions

Over time, you might need to change, disable, or audit your subscriptions. Here's how to manage them and solve common problems.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Edit or Delete a Subscription

You can see all of your subscriptions in one place. In the Power BI Service, click the gear icon in the top right corner and go to Settings. From there, select the 'Subscriptions' tab. This will show you a list of every subscription you’ve created. You can use the buttons to turn a subscription On/Off, edit its settings, or delete it entirely.

Common Troubleshooting Scenarios

• "The subscription didn't send." First, check your spam or junk folder. Then, go to the dataset settings for the report and check the 'Refresh History' to make sure the data successfully refreshed. If the refresh failed, the subscription won’t run (unless you scheduled it based on time instead of refresh).
• "The data looks old." This is almost always a data refresh issue. The subscription ran correctly, but the underlying dataset it pulled from was out of date. Check your dataset’s refresh history and fix any connection problems.
• "Recipients can't open the report link." This is a permissions issue. The recipient either does not have a Power BI license or has not been granted access to the report/workspace. To fix this, you can either share the report directly with them or edit the subscription to check the "Permission to view..." box.

Advanced Tips for Better Report Scheduling

Once you’ve mastered the basics, you can apply some advanced techniques for more powerful and personalized reporting.

Using Filters for Personalized Reports

You can send customized views of the same report to different people. For example, you can send each regional manager a report showing just their region’s data. You can achieve this in two primary ways:

1. Manually Filter and Subscribe: Apply a filter to your report in Power BI Service before you create the subscription. Power BI will remember this filter state and apply it to an email subscription you set up during this session.
2. Row-Level Security (RLS): For a more scalable and secure solution, implement RLS in your data model. RLS automatically filters data based on the logged-in user's identity. When an RLS-enabled report is sent via subscription, each recipient will automatically receive a PDF showing only the data they are permitted to see.

Connecting with Power Automate

If you need more flexibility than what the standard Subscription feature offers - like conditional notifications, custom email formatting, or sending reports to dynamic lists of people not within your organization - your next step is Power Automate. Your ability to connect Power BI as a trigger with services such as Outlook will unlock endless customization for your workflows and reporting needs.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Scheduling reports in Power BI is a powerful feature that automates stakeholder communication, ensuring timely delivery of key insights and fostering a more data-informed culture. By configuring email subscriptions correctly and aligning them with data refreshes, you can create a reliable "set it and forget it" reporting system for your organization.

While Power BI makes scheduling easier, it can still take hours for data teams to build the complex reports that your team ends up subscribing to. We built Graphed on the idea that getting real-time answers and building marketing and sales dashboards shouldn't require that level of technical overhead. You simply connect your data sources in a few clicks, then ask for the dashboards and reports you need using plain English. Instead of waiting for a daily scheduled report, marketers and sales teams can build what they need in seconds and always work with real-time, live data, not static PDF snapshots.