How to Schedule Power BI Reports

Here's the converted Markdown version of the provided HTML content:

Graphed

Still Building Reports Manually?

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

Watch the Demo

You've built the perfect Power BI report that visualizes your team's key metrics, but its value is limited if you're the only one who sees it. The real power comes from getting that data into the hands of stakeholders consistently and automatically. This article will walk you through exactly how to schedule Power BI reports, so you can automate your data delivery and free yourself from manually sending out updates.

Why Automate Your Power BI Reports?

Before jumping into the "how," let's quickly cover the "why." Manually exporting and emailing reports every week is not just tedious, it's a huge time sink that could be better spent on actual analysis. Scheduling your reports completely changes the game.

• Saves You Time and Effort: This is the most obvious benefit. Set it up once, and your work is done. No more recurring calendar reminders to pull and send the latest numbers. It frees you up to focus on finding insights, not just distributing data.
• Ensures Consistency: Automated reports go out on a reliable schedule, ensuring everyone receives the data at the same time and in the same format. This eliminates discrepancies and makes sure decisions are based on a single source of truth.
• Empowers Your Team: When stakeholders automatically receive a summary of KPIs in their inbox, they’re more likely to stay engaged with the data. Whether it's a sales leader getting a Monday morning pipeline review or a marketing team receiving a weekly campaign performance summary, consistent data access promotes a more data-driven culture.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Prerequisites: What You Need Before You Start

Setting up scheduled reports in Power BI is straightforward, but you need a few things in place first. Make sure you've covered these bases to avoid any roadblocks.

• A Power BI Pro or Premium License: Scheduling is a feature of the Power BI Service (the online version of Power BI), which requires a paid license. A Power BI Pro license works for individual users, while Power BI Premium is for larger organizations and offers enhanced capacity. You cannot set up subscriptions with a free license.
• Published Report in the Power BI Service: You build reports in Power BI Desktop, but you manage and share them from the Power BI Service. Before you can schedule anything, you must first publish your report from the Desktop app to a workspace in the Service.
• Configured Data Source Credentials: For automation to work, Power BI needs to be able to access your underlying data sources to refresh your dataset. This means you must provide credentials (like a username/password or an API key) for each data source so that Power BI can connect to them without you being present.

Step-by-Step Guide to Scheduling Power BI Reports via Email Subscription

The primary way to schedule a report in Power BI is to set up an email subscription. This sends a snapshot of the report to specified recipients on a schedule you define. Here’s how to do it:

Step 1: Publish Your Report and Navigate to the Power BI Service

If you haven't already, open your completed report in Power BI Desktop. Click the Publish button on the Home tab of the ribbon. Choose the workspace where you want the report to live and complete the publishing process.

Once published, log in to the Power BI Service at app.powerbi.com and navigate to the workspace containing your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Set Up a Scheduled Refresh for Your Dataset

Before you subscribe people to the report, you want to make sure the data they receive is current. An email subscription sends a snapshot of the report in its current state. If the data hasn't been refreshed, your team will get an email with old information.

First, schedule a data refresh. This tells Power BI when to pull new data from your sources.

1. In your workspace, find the dataset associated with your report. It will have the same name as the report and a different icon.
2. Hover over the dataset and click the ellipsis icon (...), then select Settings.
3. In the Settings pane, expand the Data source credentials section. Click Edit credentials and provide the necessary authentication information for Power BI to access your data source automatically.
4. Next, expand the Scheduled refresh section. Toggle it on.
5. Configure the refresh frequency. Depending on your data source and license, you can set it to Daily or Weekly. For Daily refreshes, you can add multiple specific times per day (Pro licenses allow up to 8 daily refreshes).
6. Select your Time zone to ensure the refresh happens at the correct time locally, and click Apply.

Pro Tip: Always schedule the data refresh to occur before your email subscription is set to go out. For example, if you want to email the report at 9:00 AM, set the data refresh for 8:30 AM.

Step 3: Create the Email Subscription

Now that your data is set to refresh automatically, you can create the subscription that sends the report to your team.

1. Open the report itself from your workspace.
2. In the menu bar at the top of the report, look for the Subscribe button (it has an envelope icon). Click it.
3. A pane will appear on the right side of your screen. Click + Add new subscription.
4. Give your subscription a name: Be descriptive, like "Weekly Marketing KPI Report for Leadership."
5. Enter recipient emails: In the "Subscribe" box, type the email addresses of the people who should receive the report. You can add individuals or entire Office 365 groups.
6. Edit the Subject and Message: Customize the email subject and add a brief message. This provides context so recipients aren't surprised by an automated email. For example, "Here is this week's summary of marketing campaign performance."
7. Select the Report Page: If your report has multiple pages, you can choose to send the entire report or just a specific page from the dropdown menu.
8. Set the schedule: This is the core of scheduling. Define the frequency (Hourly, Daily, Weekly, Monthly) and your desired Time Zone. You can choose specific days and times.
9. Choose additional options:
10. Review your settings and click Save and close at the bottom.

That's it! Your report is now scheduled to refresh its data and send an update directly to your team's inboxes a few minutes past your scheduled send time automatically. You can manage your subscriptions at any time by returning to the "Subscribe" menu on the report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices and Quick Tips

• Test First, Then Deploy: Before adding your entire list of stakeholders, create a test subscription for just yourself or a coworker. This helps you confirm the formatting, refresh timing, and delivery all work as expected.
• Match Attachment to Audience: Sending a PDF is great for a high-level, static summary. Including a link to the report is better for users who are comfortable with Power BI and want to interact with the data by clicking on charts and applying filters.
• Manage Expectations: Tell your recipients that they will start receiving an automated report. It builds trust and ensures your email doesn't get tossed into a spam folder.
• Check your Refresh History: If stakeholders report that the data looks stale, the first place to check is your dataset's Refresh History (under Settings). This will tell you if a scheduled refresh failed and provide error details, which are often related to expired data source credentials.

Final Thoughts

Scheduling Power BI reports transforms them from static dashboards you have to manually share into an active, automated communication tool for your team. By setting up scheduled refreshes and email subscriptions, you can save valuable time, ensure consistent delivery, and empower your organization with the data it needs to make timely decisions.

While Power BI is a powerful tool for visual analysis, getting everything connected and automated often involves multiple steps and a significant learning curve. At Graphed, we believe accessing your data should be as easy as asking a question. We built our platform so you can connect your marketing and sales data sources in seconds and create real-time dashboards using simple, natural language. Instead of navigating settings panes and configuring schedules, you can just ask, "Show me my Facebook Ads ROI by campaign this month," and get a live, shareable dashboard instantly.