Edit

Save a paginated report to OneDrive for work or school or SharePoint Online

  • Article

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 use Power Automate to automate saving a Power BI paginated report to OneDrive for work or school or a SharePoint Online folder.

Screenshot of the Power Automate flow for saving a paginated report to OneDrive or SharePoint Online

For more information about Power Automate templates for Power BI paginated reports, see Export Power BI paginated reports with Power Automate.

Prerequisites

Before you begin, make sure you meet these criteria:

  • You can publish to My Workspace, or you have at least a Contributor role for any other workspace.
  • You have access to the standard connectors in Power Automate, which come with any Office 365 subscription.

Save a paginated report to OneDrive for work or school or a SharePoint Online folder

With either of these templates, you set up recurring exports of a paginated report in a desired format to OneDrive for work or school or a SharePoint Online folder. See the prerequisites if this is your first time using the Export to File for Paginated Reports action in a Power Automate flow.

Note

The following steps and images show setting up a flow using the Save a Power BI paginated report to OneDrive for work or school template. Follow the same steps to create a flow using the Save a Power BI paginated report to a SharePoint Online folder template. When selecting where you want to export your paginated report, select a SharePoint Online folder instead of a OneDrive for work or school folder.

  1. Go to flow.microsoft.com and sign in to Power Automate.

  2. Select Templates, and search for paginated reports.

    Screenshot that highlights the templates icon and the search field.

  3. Select Save a Power BI paginated report to OneDrive for work or school or Save a Power BI paginated report to a SharePoint Online folder. Make sure you're signed into Power BI and OneDrive for work or school or SharePoint Online.

    Screenshot of selecting the Power BI and OneDrive for work or school template.

  4. Select Continue.

  5. Select Continue.

  6. To set the recurrence for your flow, select a Frequency and enter a desired Interval value.

    Screenshot that shows the Interval and Frequency fields.

  7. For more options, select Show advanced options to set other Recurrence parameters, including Time zone, Start time, On these days, At these hours, and At these minutes.

    Screenshot that shows the advanced options for setting the recurrence.

  8. In the Workspace box, select a workspace in a reserved capacity. In the Report box, select the paginated report in the selected workspace you wish to export. In the Export Format box, select the desired export format. Optionally, you can specify parameters for the paginated report. For detailed descriptions of the API parameters, see the connector reference for the Power BI REST API.

    Screenshot that shows where to select the paginated report, the workspace, and the export format.

  9. In Folder Path, select the OneDrive for work or school or SharePoint Online folder where you want to export your paginated report.

    Screenshot that shows where to set the destination path for the file.

  10. Power Automate automatically generates a File Name and File Content for you. You can change the file name, but keep the dynamically generated File Content value.

  11. When you're done, select Next step or Save. Power Automate creates and evaluates the flow, and lets you know if it finds errors.

  12. If there are errors, select Edit flow to fix them. Otherwise, select the Back arrow to view the flow details and run the new flow.

    When you run the flow, Power Automate exports a paginated report in the specified format to OneDrive for work or school or SharePoint Online.

Related content