How many times per day can a Power BI report be refreshed?

With Power BI Pro you can schedule up to 8 daily refreshes. With Power BI Premium you can reach up to 48 refreshes per day. The exact frequency depends on your license type and business requirements. For most enterprise use cases, refreshes every 2 or 3 hours with a Pro license are more than sufficient.

What is the Power BI On-Premises Data Gateway and when is it needed?

The Power BI On-Premises Data Gateway is a service that acts as a bridge between Power BI Service (in the cloud) and data stored on local servers, such as on-premises SQL Server or files on an internal network. It is needed when data sources are not in the cloud, so that scheduled automatic refreshes can securely access that data.

How does Power Automate integrate with Power BI?

Power Automate integrates with Power BI in several ways: you can create flows that trigger when a KPI crosses a threshold in Power BI, send notifications to Teams or by email with additional context, automatically export report pages as PDFs, or embed Power Automate buttons directly in the report canvas so users can trigger actions with a single click.

Automation

Automated Reports with Power BI: Complete Guide

By Franco Gallegos · October 30, 2025 · 5 min read

If your team spends hours every week copying data, updating Excel spreadsheets, and sending reports by email, you're losing valuable time that could be invested in analyzing that information and making decisions. The good news is that Power BI allows you to fully automate the entire reporting lifecycle: from data refresh to distribution to recipients.

In this complete guide we explain all the tools and features Power BI offers so your reports update themselves, reach the right people without manual intervention, and automatically alert you when something important changes.

What Does Automating a Report in Power BI Mean?

Automating reports in Power BI covers three dimensions:

Data refresh: data sources are refreshed automatically without anyone having to do it manually.
Distribution: the report reaches the right recipients at the right time, without anyone needing to send it.
Alerts: the system actively notifies when a KPI exceeds or falls below a defined threshold.

Achieving all three dimensions transforms a static report into a living business intelligence system that works for your company 24 hours a day.

Step 1: Scheduled Data Refresh in Power BI Service

For a report to update automatically, you need to publish it to Power BI Service (Power BI's cloud version) and configure a gateway if your data is on local servers.

Configure Scheduled Refresh

Publish your report from Power BI Desktop to Power BI Service.
In the workspace, click the corresponding dataset and select "Schedule refresh".
Enable the "Keep your data up to date" option.
Choose the frequency: you can configure up to 8 daily refreshes on a Pro license and up to 48 on Premium.
Select the time slots when you want the refresh to run.

With this configured, Power BI will automatically connect to your data sources (SQL databases, SharePoint, cloud files, APIs) and update the report's data on the schedule you define.

Data Gateway for On-Premises Sources

If your data is on local servers (on-premises SQL Server, files on a local network), you need to install the Power BI On-Premises Data Gateway. This service acts as a bridge between the cloud and your local systems, enabling automatic refresh without exposing your data directly to the internet.

Step 2: Subscriptions and Email Distribution

Power BI Service allows you to set up email subscriptions so users receive a snapshot of the updated report in their inboxes on a schedule.

Page Subscriptions

Open the report in Power BI Service.
Click the envelope icon (Subscribe) in the top bar.
Configure the subscription name, frequency (daily, weekly, monthly), and recipients.
Choose whether to also send as a PDF or image attachment.

Subscriptions are especially useful for executives who prefer to receive a daily visual summary without actively accessing the platform.

Step 3: Data Alerts on KPIs and Cards

One of the most powerful automation features is the ability to create data alerts directly on KPI, gauge, and card visuals in Power BI Service.

How to Configure an Alert

Pin the KPI visual to a Power BI Service dashboard (not the report, but the dashboard).
Click the three dots on the visual and select "Manage alerts".
Define the threshold: for example, alert when "Monthly Sales" falls below $500,000.
Choose whether to receive the alert by email or as a notification in the Power BI mobile app.

Alerts work regardless of whether you have the report open. Power BI checks the value every time the dataset is updated and sends the notification if the condition is met.

Step 4: Power Automate for Advanced Flows

Power Automate (formerly Microsoft Flow) integrates directly with Power BI to create more sophisticated automations that go beyond basic alerts.

Example Flows with Power Automate and Power BI

Alert with context: when a KPI falls below the threshold, send an email with the current value, variance against target, and a direct link to the report filtered by the relevant period.
Teams notification: when report data is refreshed, automatically send a message to the commercial team's Teams channel with the day's summary.
Data-triggered action: when a sale exceeds a certain amount in the dataset, automatically create a task in Planner or a ticket in the CRM for follow-up.
Scheduled export: automatically export report pages as PDFs and save them to SharePoint or send them as attachments.

Embed Power Automate in a Report

From Power BI Desktop you can also insert a Power Automate button directly into the report canvas. This allows users to trigger workflows with a click from within the dashboard itself: for example, triggering an export, approving a request, or creating a comment in an external system.

Step 5: Publishing via Apps and Shared Workspaces

To distribute reports in a controlled way to multiple users within the organization, Power BI offers Power BI Apps. An app is a published container that groups related reports and dashboards under a unified experience.

The advantages of distributing via apps:

Users always access the most recent version without anyone having to notify them.
You can control which parts of the content each user group can see.
You can update the app's content without users noticing any interruptions.
No need to give access to the development workspace.

Step 6: Embedding Reports in Your Own Portals

For organizations that want to integrate Power BI reports into their own web applications or internal portals, Power BI offers embedding functionality via the Power BI API. This allows you to display interactive reports with full cross-filtering inside any application without users needing a Power BI Pro license.

Best Practices for Automated Reports

Design the model with automation in mind: Power Query flows must be robust against changes in the structure of source data.
Set up error notifications: Power BI can send you an email if a scheduled refresh fails, so you can intervene quickly.
Limit alert recipients: too many notifications create "alert fatigue". Only alert when action is truly necessary.
Document your flows: record what refreshes, how often, and who receives what, to make maintenance easier.
Review refresh timing: schedule refreshes to occur before users need the data (e.g., if the sales team reviews reports at 8am, schedule the refresh at 6am).

The Real Impact of Automation

In our experience working with companies across Latin America and internationally, automating reports with Power BI generates an immediate and measurable impact. Teams stop spending hours each week on manual preparation tasks, and leaders receive reliable, up-to-date information without depending on someone remembering to send it. To see how much time you could recover, we recommend reading our article on how to reduce reporting time.

Want Reports That Update Themselves?

We implement complete automation pipelines in Power BI: data refresh, smart alerts, and automatic distribution to your team. Request a free demo.

Request a Demo

Frequently Asked Questions

How many times per day can a Power BI report be refreshed?: With Power BI Pro you can schedule up to 8 daily refreshes. With Power BI Premium you can reach up to 48 refreshes per day. The exact frequency depends on your license type and business requirements. For most enterprise use cases, refreshes every 2 or 3 hours with a Pro license are more than sufficient.
What is the Power BI On-Premises Data Gateway and when is it needed?: The Power BI On-Premises Data Gateway is a service that acts as a bridge between Power BI Service (in the cloud) and data stored on local servers, such as on-premises SQL Server or files on an internal network. It is needed when data sources are not in the cloud, so that scheduled automatic refreshes can securely access that data.
How does Power Automate integrate with Power BI?: Power Automate integrates with Power BI in several ways: you can create flows that trigger when a KPI crosses a threshold in Power BI, send notifications to Teams or by email with additional context, automatically export report pages as PDFs, or embed Power Automate buttons directly in the report canvas so users can trigger actions with a single click.

Our Services

Want to Automate Your Reports?

We set up the full automation cycle in Power BI so your team always has up-to-date information with zero manual work.