Export Power BI paginated reports with Power Automate
With Power Automate, you can automate the export and distribution of Power BI paginated reports to supported formats and scenarios. In this article, you learn which templates you can 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.
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.
You can also follow along if you have a Power BI Premium Per User (PPU) license but you're limited to one export within a five-minute window.
Create a flow from a template
Go to flow.microsoft.com and sign in to Power Automate.
Select Templates, and search for paginated reports.
Select a template
Select a template from the following list to start the step-by-step walkthrough.
- Save a Power BI paginated report to OneDrive for work or school or a SharePoint Online folder.
- Export a Power BI paginated report for items in a SharePoint Online List, or for each row in an Excel Online table.
- Save a Power BI paginated report to a local system folder.
Considerations and limitations
When you use Power Automate to export a paginated report that takes more than two minutes to download, the export fails due to the Power Automate outbound synchronous request limitation.