Export and email a Power BI report with Power Automate

  • 2 minutes to read

With Power Automate, you can automate exporting and distributing Power BI reports to a variety of formats and scenarios. In this article, you create your own flow from scratch. You use the Export to File for Power BI Reports action to automatically distribute a Power BI report via email.

Power Automate steps to export and email a report.

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 A1/EM1 - 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.

Create a flow from scratch

In this task, you create a simple flow from scratch. The flow exports a Power BI report as a PDF, and attaches it to an email to be sent on a weekly basis.

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

  2. Select Create > Scheduled flow.

    Create a scheduled flow in Power Automate.

  3. In Build a scheduled flow, give your flow a name.

  4. In Run this flow, select the starting date and time for your flow, as well as the repetition frequency.

  5. In On these days, select which days you want your flow to run, and select Create.

    Power Automate, schedule the flow.

  6. In Recurrence, select Show advanced options and enter a value in At these hours and At these minutes to set a specific time for your flow to run.

    Set recurrence in Power Automate.

  7. Select New Step.

  8. In Choose an action, search for Power BI and select Export to File for Power BI Reports.

    Choose an action in Power Automate.

  9. In Export to File for Power BI Reports, select a Workspace and Report from the dropdowns.

  10. Select the desired Export Format for your Power BI report.

    Select export format in Power Automate.

  11. Optionally, indicate specific pages to export in the Pages pageName -1 field. Note the page name parameter is different from the display page name. Find the page name by navigating to the page in the Power BI service, and copying the last portion of the URL.

    Select the pane name in the U R L.

  12. Optionally, indicate a specific bookmark to display in the Pages Bookmark Name field. As with the page name parameter, you find the bookmark name parameter in the report URL. You can specify additional parameters for the Power BI report. Find detailed descriptions of these parameters in the connector reference for the Power BI REST API.

    Select the bookmark name in the U R L.

  13. Select New Step.

  14. In Choose an action, search for Outlook and select Send an email (V2).

  15. In Send an email (V2), complete the To, Subject, and Body fields for your email.

  16. Select Show advanced options. In Attachments Name – 1, enter a name for your attachment. Add a file extension to the file name (for example, .PDF) that matches your desired Export Format.

  17. In Attachment Content, select File Content to attach your exported Power BI report.

    Select your exported report to email.

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

  19. 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 Power BI report in the specified format and sends it as an email attachment as scheduled.

Next steps