Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
Note
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.
Go to flow.microsoft.com and sign in to Power Automate.
Select Templates, and search for paginated reports.
Select a template from the following list to start the step-by-step walkthrough.
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.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Create Power BI reports with Power Automate Process Mining - Training
Learn how to create Power BI reports with Power Automate Process Mining.
Certification
Microsoft Certified: Power Automate RPA Developer Associate - Certifications
Demonstrate how to improve and automate workflows with Microsoft Power Automate RPA developer.
Documentation
Save a paginated report to a local folder with Power Automate - Power BI
In this article, you use a template to set up recurring exports of a paginated report to your file system, in a desired format.
Save a paginated report to OneDrive for work or school or SharePoint Online - Power BI
In this article, you use Power Automate to automate saving a Power BI paginated report to OneDrive for work or school or a SharePoint Online folder.
Export a paginated report for each row in an Excel Online table or SharePoint list - Power BI
In this article, you use Power Automate to automate exporting a paginated report for each row in an Excel Online table or SharePoint Online list.