Export Power BI paginated reports with Power Automate

With Power Automate, you can automate exporting and distributing Power BI paginated reports to a variety of supported formats and scenarios. In this article, you learn which templates to use to build your own flows to export your paginated reports.

Power Automate is a no-code way to interact with the Export To File API in the user interface. See the connector reference article for the Power BI REST API to start interacting with the API directly.

Prerequisites

To follow along, make sure you have:

  • At least one workspace in your Power BI tenant backed by a reserved capacity. This capacity can be any of the A4/P1 – A6/P3 SKUs. Read more about reserved capacities in Power BI Premium.
  • Access to the standard connectors in Power Automate, which come with any Office 365 subscription.

Note

You can also follow along if you have a Power BI Premium Per User (PPU) license but you will be limited to one export within a five minute window.

Create a flow from a template

  1. Sign in to Power Automate flow.microsoft.com.

  2. Select Templates, and search for paginated reports.

    Screenshot of Power Automate templates for Power BI paginated reports.

Select a template

Select a template from the list to get started with a step-by-step walkthrough.

Considerations and limitations

When using Power Automate to export a paginated report that takes more than two minutes to download, the export will fail due to Power Automate’s outbound synchronous request limitation.

Next steps