Power BI Subscriptions & Power Automate

Hey lherbert501 ,

Yes, many organizations have replaced SSRS subscriptions with Power BI + Power Automate, but it works a little differently and there are some limitations you should be aware of.

It is absolutely possible to send report outputs as email attachments, but the setup depends on your licensing and how close you need it to behave like classic SSRS subscriptions.

In SSRS, subscriptions are very straightforward: render report → attach PDF/Excel → email on schedule. Power BI does not natively replicate that exact behavior unless you use Premium features or Power Automate.

There are three common approaches.

First option is Power BI Subscriptions (native feature). In the Power BI Service, you can subscribe users to a report page or dashboard and schedule email delivery. However, standard subscriptions typically send a snapshot image and a link, not a file attachment. If you have Power BI Premium (or Fabric capacity), you can attach PDF or PPT exports. Without Premium, attachment options are limited.

Second option is Power Automate + “Export to File for Power BI Reports” connector. This is the closest replacement for SSRS subscriptions. The flow works like this: on a schedule → export Power BI report to PDF or PPT → send email with attachment. This requires:

• Power BI Premium capacity (or Fabric capacity), OR
• Premium Per User (PPU) license for both the report workspace and the user running the flow.

This method gives you true file attachments like SSRS did.

Third option is using Paginated Reports in Power BI. If your SSRS reports are paginated-style reports (pixel-perfect, tabular, invoice-style), then the best replacement is actually Power BI Paginated Reports. These support subscriptions very similar to SSRS, including file attachments in multiple formats. This is the most direct SSRS replacement but again, it requires Premium or PPU.

Things to consider before migrating:

• Licensing — SSRS often came “included” with SQL Server. Power BI scheduled exports with attachments usually require Premium/PPU.
• Security model — Power BI uses workspace and dataset permissions rather than folder-based SSRS security.
• Parameterized reports — Power Automate can handle parameters, but it requires extra configuration.
• Volume — Large distribution lists may hit API or flow limits.

If your goal is simply: “Send users a PDF or Excel file on a schedule like SSRS did,” then yes, it is possible but you’ll likely need Premium/PPU and Power Automate or Paginated Reports.

If this explanation helped, please mark it as the solution so others can find it easily.

If it helped, a quick Kudos is always appreciated it highlights useful answers for the community.

Thanks for being part of the discussion!