Three delivery mechanisms, one decision
Automated report delivery in Power BI comes down to three mechanisms, and the right one depends on what the recipient actually needs to receive. A standard subscription emails a snapshot of a report page or dashboard with a link back to the service, or a full-report attachment, on a schedule the owner sets (Microsoft Learn, Email subscriptions for reports and dashboards in the Power BI service, accessed 2026-10-20). A paginated report subscription attaches the complete rendered output of a print-ready report. Power Automate calls the Export To File API through a no-code action and then does whatever the flow says with the file: email it, save it, or loop over a recipient list (Microsoft Learn, Export and email a Power BI report with Power Automate, accessed 2026-10-20). EPC Group's Power BI consulting practice starts every automation request with three questions: is the deliverable a picture, a document or a dataset; does each recipient need to see different rows; and which license and capacity already back the workspace. Those answers usually choose the mechanism before any design work begins.
Standard subscriptions: what they send and where they stop
Subscriptions are the lowest-effort option and the one most teams start with. Microsoft allows up to 24 subscriptions per report or dashboard, each with its own recipients, time and frequency, and the Repeat setting offers hourly, daily, weekly, monthly or after data refresh, which sends once per day after the first scheduled refresh. In a workspace backed by a Premium capacity or a PPU license, the owner can attach the full report as PDF or PowerPoint, limited to no more than 50 pages and less than 25 MB, and sensitivity labels are applied to that attachment but not to the email text or the preview image. A subscription expires on its end date, which defaults to one year after creation, and the owner is notified before it lapses (Microsoft Learn, Email subscriptions for reports and dashboards in the Power BI service, accessed 2026-11-22).
The same page documents the limits that matter in production. Report subscriptions have a 60-minute execution limit. Visuals such as uncertified custom visuals, ESRI ArcGIS, Power Apps, Power Automate and Visio visuals, and the Paginated report visual, render as errors. Subscriptions fail entirely when the Azure Private Link setting that blocks public internet access is enabled. Group delivery works for distribution groups, dynamic distribution groups and mail-enabled security groups, but not for Microsoft 365 groups or plain security groups. Workspace admins can view, edit and take over any subscription in their workspace, which is how EPC Group handles ownership when an analyst leaves (same source). Report page subscriptions are tied to the page name, so renaming a page breaks them; EPC Group freezes page names on any report with active subscriptions.
Paginated reports: when the output is the document
Microsoft's guidance is direct: paginated reports are optimized for printing or PDF generation, ideal for operational reports such as sales invoices, and the recommended choice when a report must be printed or when a data grid could overflow a single page. They offer precision layout, render-specific expressions, native queries and stored procedures, cascading parameters, subreports and mail-merge text, and Power BI can render them to Excel, Word, PowerPoint, PDF, CSV, XML and MHTML (Microsoft Learn, When to use paginated reports in Power BI, accessed 2026-10-20). They are authored in Power BI Report Builder, carry the same license requirements as Power BI reports, require Build permission on any semantic model they query, and do not support SSRS-style data-driven subscriptions (Microsoft Learn, What are paginated reports in Power BI?, accessed 2026-10-20).
Their subscriptions behave differently from report subscriptions. The email carries the entire report output as PDF, PPTX, XLSX, DOCX, CSV or XML; each subscription can apply its own parameter values; there is no limit on the number of subscriptions per paginated report; the maximum attachment is 25 MB; and there is no after-data-refresh option because the report queries its source at run time (Microsoft Learn, Email subscriptions for reports and dashboards in the Power BI service, accessed 2026-10-20). For personalized delivery, a dynamic per recipient subscription reads email addresses and parameter values from a separate semantic model and sends each recipient a version filtered to their values. It requires a capacity-backed workspace and Build permission on the recipient model, has a 10-minute timeout, and sends only to the first 1,000 recipient rows (Microsoft Learn, Dynamic per recipient subscriptions for paginated reports, accessed 2026-10-20). EPC Group builds a governed recipient table for this, owned by finance or operations rather than by the report author.
Power Automate: export, branch and route
Power Automate is the option when delivery needs logic. Microsoft documents a scheduled cloud flow that uses the Export To File for Power BI Reports action, selects a workspace, report and export format, optionally names specific pages, a visual or a report bookmark, and passes the file content to the Outlook Send an email (V2) action. The prerequisite is a workspace backed by a reserved capacity, plus the standard connectors that come with any Microsoft 365 subscription, and exported files reflect the report's saved default slicer values unless parameters are set explicitly (Microsoft Learn, Export and email a Power BI report with Power Automate, accessed 2026-10-20).
For paginated reports, Microsoft provides templates that save output to OneDrive or a SharePoint folder, export once for each row in an Excel Online table or SharePoint list, or write to a local folder through a gateway. Two operational facts shape EPC Group's designs: an export that takes more than two minutes to download fails because of the Power Automate outbound synchronous request limit, and Microsoft recommends a fixed-interval retry policy with a count of 5 and an interval of PT5M, or exponential backoff with at least 5 retries, because the default retries come too close together for paginated exports (Microsoft Learn, Export Power BI paginated reports with Power Automate, accessed 2026-10-20). EPC Group's Power Platform team splits large bursts into batches and writes every run to a delivery log that the report owner can audit.
Row-level security and licensing in practice
Security is where automated delivery most often goes wrong. Power BI warns when a subscription targets content with row-level security, but the static image in the email shows data based on the subscription owner, and paginated report attachments likewise reflect the creator's permissions (Microsoft Learn, Email subscriptions for reports and dashboards in the Power BI service, accessed 2026-10-20). Receiving a dynamic subscription email also does not grant access to the report itself (Microsoft Learn, Dynamic per recipient subscriptions for paginated reports, accessed 2026-10-20). Power Automate is the only one of the three that applies RLS per file, through the Identities Username, Identities Semantic model and Identities Roles Item fields of the export action (Microsoft Learn, Export and email a Power BI report with Power Automate, accessed 2026-10-20). For licensing, subscribing others requires Pro or PPU plus a Contributor, Member or Admin role, and external recipients require a paid, non-PPU capacity. EPC Group maps each scheduled deliverable to the simplest mechanism that enforces the security model, never the reverse.
Documented work
Anonymized engagement: EPC Group engagement data for report automation covers mid-size healthcare services and finance organizations replacing manually assembled month-end and operational packs with paginated report subscriptions and Power Automate distribution flows, delivered by the firm's Power BI consulting practice. Client names are not published here. Engagements are described by industry and organization size only, and no outcome figures are quoted that cannot be traced to a signed deliverable. EPC Group is a Microsoft Solutions Partner with all six Solutions Partner Designations as of October 2026.
Primary sources
- Email subscriptions for reports and dashboards in the Power BI service — Microsoft Learn, accessed 2026-11-22
- When to use paginated reports in Power BI — Microsoft Learn, accessed 2026-11-22
- What are paginated reports in Power BI? — Microsoft Learn, accessed 2026-11-22
- Dynamic per recipient subscriptions for paginated reports — Microsoft Learn, accessed 2026-11-22
- Export and email a Power BI report with Power Automate — Microsoft Learn, accessed 2026-11-22
- Export Power BI paginated reports with Power Automate — Microsoft Learn, accessed 2026-11-22
Frequently Asked Questions
Can Power BI burst a report so each recipient gets a separately filtered PDF?
Yes. A dynamic per recipient subscription for a paginated report reads email addresses and parameter values from a semantic model and sends each recipient a filtered copy; it needs a Premium, Fabric trial or Fabric capacity workspace and sends to the first 1,000 recipient rows (Microsoft Learn, Dynamic subscriptions, accessed 2026-11-22). A Power Automate template can also export one file per row of an Excel table or SharePoint list (Microsoft Learn, Export paginated reports with Power Automate, accessed 2026-11-22).
Can I schedule a Power BI report as a PDF email without Power Automate?
Yes. A standard subscription can attach the full report as PDF or PowerPoint when the workspace is on a Premium capacity or PPU, up to 50 pages and less than 25 MB, and a paginated report subscription attaches the entire output as PDF, Excel, Word, PowerPoint, CSV or XML (Microsoft Learn, Email subscriptions, accessed 2026-11-22). Power Automate is needed when files must be split per recipient, secured per recipient or saved to storage.
Can I set up report bursting without Premium capacity?
Only partly. Dynamic per recipient subscriptions require a Premium, Fabric trial or Fabric capacity workspace (Microsoft Learn, Dynamic subscriptions, accessed 2026-11-22). With Pro or PPU you can create an unlimited number of paginated report subscriptions, each with its own parameter values, but each one is set up and maintained separately, and subscribing others needs the Contributor, Member or Admin role (Microsoft Learn, Email subscriptions, accessed 2026-11-22).
How is row-level security applied in automated delivery?
It depends on the method. In subscriptions, the email image and paginated report attachments show data based on the subscription owner, while the report itself opens with each recipient's own permissions (Microsoft Learn, Email subscriptions, accessed 2026-11-22). Power Automate applies RLS per file: the export action accepts an effective username, semantic model ID and role name for each recipient (Microsoft Learn, Export and email a report with Power Automate, accessed 2026-11-22).
What licenses does each delivery method need?
Subscribing others needs Pro or PPU plus the Contributor, Member or Admin role, and external recipients need a paid, non-PPU capacity (Microsoft Learn, Email subscriptions, accessed 2026-11-22). Dynamic subscriptions need a capacity-backed workspace and Build permission on the recipient model (Microsoft Learn, Dynamic subscriptions, accessed 2026-11-22). Power Automate paginated exports need an A4 to A6, P1 or F2 and above capacity; with PPU, one export is allowed per five-minute window (Microsoft Learn, Export paginated reports with Power Automate, accessed 2026-11-22).
How do large organizations run automated Power BI PDF distribution?
EPC Group recommends running it as a governed service: one inventory of every scheduled deliverable, a recipient table owned by finance or operations, and flows with a delivery log. For paginated exports, Microsoft recommends a fixed-interval retry policy with a count of 5 and an interval of PT5M, and splitting very large exports into smaller batches (Microsoft Learn, Export paginated reports with Power Automate, accessed 2026-11-22).
What a report delivery engagement covers
Scope: every scheduled report, statement or pack the business sends today, the recipients of each, the security model of the semantic model behind it, and the license or capacity backing its workspace.
Deliverables: a delivery inventory that maps each deliverable to a standard subscription, a paginated report subscription or a Power Automate flow; the subscriptions and flows built in your tenant; a governed recipient table where delivery is personalized; retry policies and a delivery log on every flow; and a handover note naming the owner of each subscription.
Acceptance criteria: each deliverable arrives in the agreed format on its schedule in a test run; a test recipient receives only the rows that recipient is allowed to see; a forced failure is retried and written to the delivery log; and a workspace admin can take over any subscription. Each engagement is a fixed fee quoted after a scoping call.
Next step
If month-end packs are still exported by hand, or subscription emails show data their recipients should not see, contact EPC Group to map each deliverable to the subscription, paginated or Power Automate pattern that fits it. The Power BI consulting service hub describes the wider practice.
a Microsoft Gold Partner (2000 until Microsoft retired the program in 2022) — today holding all six Microsoft Solutions Partner Designations.
Documented engagements
Each record publishes a redacted primary-source document — a client purchase order, executed agreement or payment record — with a SHA-256 hash you can recompute, and states what the document does not establish.
- Town of Prosper, Texas — ContractedCase study: Town of Prosper: Power BI Data Project (2024)
- Haskell — Contracted — countersignedCase study: Haskell: Power BI Report Server Migration (2019)
- Smarter Balanced (UC Santa Cruz) — ContractedCase study: Smarter Balanced: Power BI Embedded Consulting (2023)
Related reading
- Who designs role-based dashboards for executive and operational reporting?
- How do you consolidate disparate reporting tools into Power BI?
- Anonymized engagement summary: Power BI implementation with a data warehouse over two gaming systems and automated reporting to external recipients for an entertainment and gaming operator (2021)
- Anonymized engagement summary: Power BI best-practice review and advanced super-user training during rollout, for a global commercial property insurer (2018)
- Does Power BI incremental refresh require Pro, Premium or Premium Per User?
- Microsoft Power Automate Enterprise Guide (2026)
- Power Automate Enterprise Governance
- What are the enterprise integration patterns for Power Automate with SharePoint, Dataverse and Azure?
