How to Schedule Power BI Report to Email

You've built an insightful Power BI report, complete with compelling visuals and key metrics. The only problem? Getting it in front of the right people consistently, without manually exporting and emailing it every Monday morning. Automating your reporting isn't just a time-saver, it’s how you keep your team aligned and proactive. This article will show you exactly how to schedule your Power BI reports to be sent directly to your stakeholders' inboxes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: What You'll Need

Before diving into the setup, let's make sure you have everything in place. Trying to schedule a report without these prerequisites is a common source of frustration, so a quick check now will save you time later.

• A Power BI Pro or Premium Per User (PPU) license. The ability to create email subscriptions is a pro-level feature. Users with a free license can receive subscriptions but cannot create them.
• A report published to the Power BI service. Subscriptions are configured in the online Power BI service, not the Power BI Desktop application where you build reports.
• A report in a collaborative workspace. While you can create a subscription for a report in your personal "My Workspace," you can only email it to yourself. To send reports to colleagues and other stakeholders, the report must be published in a shared workspace.
• Access permissions for recipients. Anyone you email the report to must have the appropriate permissions to view the report and its underlying data within Power BI.
• For external users (optional): If you need to send reports to people outside your organization (like partners or clients), your report must be hosted in a workspace backed by a Power BI Premium capacity.

Step-by-Step: How to Schedule Your Power BI Report as an Email

Once you’ve confirmed you have the necessary licensing and permissions, setting up your scheduled email is a straightforward process. Follow these steps to create your first subscription.

Step 1: Open Your Report in Power BI Service

First, log in to your Power BI account at app.powerbi.com. Navigate to the workspace containing the report you wish to schedule. Click on the report to open it in the main viewing pane.

At the top of the report, you'll see a menu bar with several options like "File," "Export," and "Share." You’re looking for the Subscribe to report button. It sometimes appears with just a mail icon.

Step 2: Create a New Subscription

When you click Subscribe to report, a pane will slide out from the right side of your screen. This is where you’ll manage all subscriptions for this report. Since this is your first one, click the + Add new subscription button to begin the configuration process.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Configure Your Subscription Details

This is the core of the setup process where you define who gets the report, what it looks like, and what information is included. Let's break down each option.

1. Naming Your Subscription

While this seems trivial, giving your subscription a descriptive name is a great practice, especially if you plan to create multiple subscriptions for different audiences or schedules from the same report. For example, instead of "Subscription 1," use something specific like "Weekly Sales Update for Exec Team" or "Daily Marketing Leads for West Region." This makes managing your subscriptions much easier down the road.

2. Adding Recipients

In the "To" field, begin typing the names or email addresses of your colleagues. Power BI will search your organization's directory. You can add multiple individuals and entire Microsoft 365 groups to the distribution list. Remember, anyone you add here needs pre-existing permission to view this report in Power BI service.

Pro Tip: If your report is in a Premium workspace, you can email external users. Simply type their full email address. Power BI will flag them as an external user, but the subscription will still work.

3. Setting the Subject Line and Email Message

The subject line defaults to the title of your Power BI report, but you should customize it to provide immediate context. A subject like "[REPORT] Daily Sales KPIs - May 17, 2024" tells the recipient exactly what the email contains and when the data is from.

In the optional message body, you can add a short note explaining what the report shows, highlighting specific metrics to look at, or providing contact information for any follow-up questions. This adds a personal touch and steers your audience toward the key insights.

4. Choosing the Report Page

You don't have to send the entire report. Use the "Report Page" dropdown to select a specific page. This is incredibly useful for tailoring the email to different audiences. For instance, the Finance team might only need to see the "Budget vs. Actuals" page, while the Sales team needs the "Pipeline Performance" page. Sending only the relevant view reduces noise and makes the information more actionable.

5. Selecting the Attachment Format

Power BI gives you two choices for how the report is attached to the email: PDF or PowerPoint (PPTX). Your choice depends on how your audience will use the report.

• PDF: This is a static, high-fidelity snapshot of your report page. It's perfect for printing, archiving, or sharing a view that cannot be easily altered.
• PPTX: This option attaches a PowerPoint presentation where each report page becomes a separate, editable slide. This is ideal for stakeholders who need to grab visuals and incorporate them into their own presentations.

6. Advanced Options: Fine-Tuning Your Email

Below the attachment settings, you'll find a few checkboxes for advanced options that can enhance your automated report.

• Link to report in Power BI: Highly recommended. This includes a direct link in the email body that takes users to the fully interactive version of the report in the Power BI service. This encourages them to drill down and explore the data themselves.
• Preview image: This includes a static image of the report page directly visible in the email body. It’s a great way to grab the reader’s attention and show them the key visuals without requiring them to open the attachment.
• Permission to view the report in Power BI: Be careful with this one. If checked, Power BI will attempt to give recipients permissions to the report if they don't already have them. While convenient, it’s often better to manage permissions intentionally through workspace roles rather than automatically through subscriptions, especially for sensitive data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Set the Schedule

Now it's time to automate. In the "Schedule" section, you define how often and when the report gets sent.

Defining the Frequency

Under "Frequency," you can choose from several options:

• Hourly: Sends the report at set intervals throughout the day.
• Daily: The most common option for daily check-ins on performance.
• Weekly: Perfect for sending summary reports every Monday morning. You can select which day(s) of the week it sends.
• Monthly: Ideal for high-level performance reviews. You can pick specific days of the month.
• After data refresh (once daily): This is arguably the most powerful option for reports with fresh data. Selecting this triggers the email subscription to run as soon as the report's underlying dataset has finished its scheduled refresh. This ensures your team always receives a report with the latest possible data.

After choosing the frequency, set the desired delivery time and, crucially, select your correct Time Zone to ensure the report arrives when expected. You can also set a start and end date for the subscription, which is helpful for project-based reporting that only needs to run for a specific duration.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 5: Save and Manage Your Subscription

Once you’ve configured everything, click Save and close at the bottom of the pane. Your subscription is now active! If you want to test it immediately, find your new subscription in the list, and click the "Run now" icon (it looks like a play button). This will send a one-off email using your settings, allowing you to confirm that everything looks perfect.

You can return to this "Manage subscriptions" pane anytime by clicking the "Subscribe to report" button on the report menu. From here, you can toggle subscriptions on or off, edit existing ones, or run them manually.

Best Practices for Power BI Email Subscriptions

Setting up a subscription is easy, but making it effective requires a bit of strategy. Keep these tips in mind to get the most out of automated reporting.

• Tailor to Your Audience: Avoid a one-size-fits-all approach. Use the "Report Page" feature to send specific views to different teams. The less irrelevant information they have to sift through, the better.
• Combine with Data Alerts: While subscriptions are great for routine updates, Power BI's "Data Alerts" are better for urgent, KPI-driven notifications. You can set an alert to notify you the moment a metric crosses a certain threshold - for example, if daily sales drop below $10,000.
• Optimize for Data Freshness: An automated report is useless if its data is stale. Use the "After data refresh" schedule whenever possible, and ensure the underlying dataset is on its own reliable refresh schedule.
• Use Descriptive Subjects and Messages: A clear, informative subject line increases open rates and helps users find reports in their crowded inboxes. A little context in the body of the email goes a long way.

Troubleshooting Common Power BI Subscription Issues

Sometimes, things don’t go as planned. Here are a few common problems and how to solve them.

• Emails Aren't Arriving: First, check the spam/junk folder. Second, confirm that the recipients still have "view" access to the report. If the underlying dataset refresh fails, any subscription tied to "After data refresh" will not run. Check the dataset's refresh history for errors.
• Attached Report Shows Outdated Data: This is almost always a data refresh issue. A subscription sends a snapshot of the report in its current state. If the data hasn't been refreshed, you're mailing out old news. Go to the dataset settings and configure a scheduled refresh.
• Visuals Appear Distorted: Some custom visuals from the marketplace may not render correctly in email subscriptions. If you face this issue, test your subscription using standard Power BI visuals. Microsoft is constantly updating this functionality, so this is improving over time.

Final Thoughts

Automating your Power BI reports with email subscriptions frees you from manual, repetitive work and empowers your organization to act on data consistently. By following these steps and best practices, you can create a reliable flow of information that keeps everyone on the same page and focused on the metrics that matter.

At Graphed you can connect all your data sources like Google Analytics, HubSpot, Shopify, and Facebook Ads — building real-time dashboards using plain English questions, without complex setup or BI certifications required. We believe getting actionable insights should be easy, fast, and accessible to all teams.