Povratne informacije Uredi

Save a paginated report to OneDrive for Business or SharePoint Online

  • Članak
  • 2 min. za čitanje

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 Business or a SharePoint Online folder.

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

Looking for other Power Automate templates for Power BI paginated reports? See Export Power BI paginated reports with Power Automate.

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 for paginated reports in Power BI Premium
  • Access to the standard connectors in Power Automate, which come with any Office 365 subscription.

Save a paginated report to OneDrive for Business 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 Business 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 Business 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 Business folder.

  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.

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

    Screenshot of selecting the Power BI and OneDrive for Business template.

  4. Select Continue.

  5. To set the Recurrence for your flow, select an option in Frequency and enter a desired Interval value.

    selecting recurrence fo the flow.

  6. (Optional) Select Show advanced options to set additional Recurrence parameters, including Time zone, Start time, On these days, At these hours, and At these minutes.

    showing advanced options for recurrence.

  7. 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. Find detailed descriptions of the parameters in the connector reference for the Power BI REST API.

    selecting the paginated report, the workspace, and the export format.

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

    selecting the destination and creating the file.

  9. 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.

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

  11. 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 Business or SharePoint Online.

Next steps