Power BI report automation without the export bottleneck
Subscriptions, paginated reports and Power Automate cover a defined scope. This page states where that scope ends.
Power BI distributes reports well as long as everyone receives the same thing. The moment forty regional managers each need their own numbers in their own workbook – on a schedule, without anyone opening the service – the built-in mechanisms start showing their edges.
Mail & Deploy runs above Power BI as a reporting layer: it queries the semantic model, builds the document from your template, varies it per recipient and delivers it to the channels your teams use. One data source is included. Each additional data source is licensed separately.
If you already know you need this and want to see how it works, that's on the Power BI setup page.
What Power BI gives you out of the box
Subscriptions
Schedule a report or dashboard page and have it emailed as a PDF or PowerPoint file to a list of recipients. Set up in the service, no additional licence, no additional system.
Works well for: the same output going to an internal audience on a fixed schedule.
Paginated reports
RDL-based, pixel-perfect, multi-page output authored in Power BI Report Builder - the right answer for invoices, statements and compliance documents with strict layout requirements. Licensing depends on your tenant configuration and has changed several times since the introduction of Fabric; check the current requirements for your setup.
Works well for: high-volume, layout-critical documents where the format matters more than interactivity.
Power Automate
Subscriptions cover email plus native delivery to OneDrive and SharePoint. Everything beyond that - Teams, S3, Google Drive, FTP - is a Power Automate flow that triggers an export and routes the file onward. It becomes a maintenance surface of its own once flows multiply, and it inherits the export API limits described below.
Works well for: a handful of scheduled or event-driven exports maintained by someone who owns the flows.
Where automated Power BI reporting runs into walls
The limits teams report once distribution leaves the pilot stage.
One report, one version
A subscription sends the same file to everyone on the list. A PDF or flat export is also not the same artefact as a branded workbook in which the recipient's formulas still calculate.
Two output formats
Subscriptions leave as PDF or PowerPoint. Attaching the full report requires a Premium or PPU workspace and stays within fewer than 20 pages and under 25 MB. Excel with working formulas, Word with a required layout, HTML, CSV and XML require a separate route.
Export API ceilings
The export API requires Premium, Embedded or Fabric capacity. Under Pro it is unavailable; under Premium Per User it covers paginated reports only, at one call every five minutes, and Power BI reports are not supported at all. A flow built while a Fabric trial capacity is assigned stops working when that capacity ends.
Power BI only
Data that never entered a semantic model cannot appear in the output. Board packs that mix Qlik®, Power BI and a warehouse are assembled by hand.
Licensing by audience size
Distribution to a large audience pushes you toward capacity licensing, and recipients who never open the service may still need a licence, depending on how content is delivered.
Destinations beyond email, OneDrive and SharePoint
Email subscriptions, plus native delivery to OneDrive and SharePoint. Teams, S3, Google Drive and FTP still require Power Automate flows built and maintained per case. Each flow is a separate artefact to own, monitor and repair - and it inherits the same export limits.
Source: Microsoft Learn · License types · checked 9 September 2026
Check your configuration
Pick the setup you are planning. The assessment updates as you change it.
Assessment
This configuration runs into platform limits.
3 limits · 0 points to confirm
- Hits a limit
One report, one version
Subscriptions send the same file to everyone on the list. A genuinely different report per recipient means row-level security around it, one subscription per recipient group, or scripting.
- Hits a limit
Export API tied to capacity
The export API requires Premium, Embedded or Fabric capacity and is unavailable under Pro. Under Premium Per User it covers paginated reports only, capped at one call every five minutes; Power BI reports are not supported. A flow built during a Fabric trial stops when that capacity ends.
Reference - Hits a limit
Excel that keeps its formulas
A flat data export is not a branded workbook in which the recipient's own formulas still calculate. Mail & Deploy builds the workbook from your template instead of exporting a table.
What it takes to run this through Mail & Deploy
A workspace on Premium, Premium Per User or Fabric capacity with XMLA read access enabled, an Azure app registration, workspace access for that app, one Fabric tenant setting and release 3.6 or higher. What you need in place.
Five points that decide it
Five decisions, each with Mail & Deploy and the native Power BI options compared directly. These five carry the whole comparison; sources, channels and monitoring are stated inside them.
Distribution
One report, one version - or one document per recipient
Mail & Deploy
One template and one rule: Mail & Deploy queries the semantic model once and produces one document per distinct value of the column you burst on, paired with the right recipient. An execution calendar, log files and a monitoring app cover every run across all reports and channels.
Native Power BI
Per-recipient output has to be built around the subscription: row-level security, one subscription per recipient group, or a script someone maintains. Status is read per subscription in the service and per flow in Power Automate.
What this means in practice: adding a recipient is a row in a list, not another subscription to maintain.
Source: Subscriptions in the Power BI service · checked September 2026
API limits
What the export API allows
Mail & Deploy
Mail & Deploy reads the semantic model through XMLA endpoints, which require Premium, Premium Per User or Fabric capacity - the same licence tier the export API needs. On that licence there is no per-user call ceiling and no five-minute export window: report volume is a question of scheduling, and parallel execution tasks scale with the edition.
Native Power BI
The export API requires Premium, Embedded or Fabric capacity and is unavailable under Pro. Under Premium Per User it covers paginated reports only, capped at one call every five minutes; Power BI reports are not supported. A flow built on trial capacity stops when that capacity ends.
What this means in practice: on the licence you already need, you are no longer limited to one export every five minutes, one source, and the same file for everyone.
Source: Premium Per User FAQ · checked September 2026
Formats
The format the recipient actually works in
Mail & Deploy
PDF, Excel, Word, PowerPoint, HTML, CSV and XML, built from your template - an Excel workbook keeps its formulas, a Word document keeps its required layout. Delivery runs to email, file server, FTP, Microsoft SharePoint and Teams, OneDrive, Dropbox, AWS S3, Google Drive, or the Mail & Deploy Hub.
Native Power BI
Subscriptions deliver PDF and PowerPoint by email, plus native delivery to OneDrive and SharePoint. Teams, S3, Google Drive and FTP still require Power Automate flows built and maintained per case. Paginated reports add pixel-perfect RDL output for layout-critical documents.
What this means in practice: finance keeps working in the file instead of rebuilding it.
Source: Export Power BI report to file · checked September 2026
Sources
More than one source in one document
Mail & Deploy
A single report can draw a chart from Qlik®, a table from a Power BI semantic model and a figure from a warehouse - Qlik Sense®, QlikView®, SQL Server, Oracle, Snowflake, BigQuery, Excel and CSV, plus Databricks and other sources via ODBC, feed one branded document.
Native Power BI
Output is built from Power BI content. Data that never entered a semantic model stays outside the report.
What this means in practice: the board pack is generated rather than assembled by hand.
Cost
What it costs when the recipient list grows
Mail & Deploy
Licensing follows the number of report recipients, with no report limit and no user limit.
Native Power BI
Large audiences push you toward capacity licensing; depending on delivery, recipients may still need a licence.
What this means in practice: growth in readership is priced at the recipient tier rather than at the capacity step.
Source: Features by licence type · checked September 2026
Need the full comparison?
We will send you the comparison as a PDF so that you can share it with your team.
When the native options are enough
If your reporting is a handful of scheduled exports going to a fixed internal distribution list, out of Power BI alone, subscriptions do that - they are included in what you already pay, and adding a platform on top would be waste. Come back when your recipient list grows or when finance asks for a workbook that still calculates.
One hour, together, on your data.
Against one of your Power BI workspaces, we connect one data source and build a first report with you - without elaborate formatting. In the two complimentary onboarding hours, we get together as far as your report allows.
- Connects to one workspace and semantic model
- Bursts one report by the column you name
- Ends with a working task you can keep
- Guided onboarding included