Edit

Share via

Create a Power Automate visual for Power BI

  • Article

APPLIES TO: Power BI Desktop Power BI service

When you create a Power Automate visual in a Power BI report, your end-users can run an automated flow, just by clicking a button in your report. Furthermore, the flow can be data contextual, meaning that the flow inputs can be dynamic, based on the filters the end-users set.

Screenshot shows Flow button resized and repositioned on the report.

Add the Power Automate visual

  1. Select the Power Automate icon from the Visualizations pane.

    Screenshot of selecting the Power Automate icon from the Visualizations pane

    In Power BI Desktop, you can also add the visual from the ribbon. On the Insert tab, select Power Automate in the Power Platform section.

    Screenshot of selecting the Power Automate icon from the Insert ribbon.

    Once you select the visual, it automatically gets added to your current report page, with getting started instructions.

  1. Scroll, resize the visual, or select the Focus mode icon to see all the instructions.

    Screenshot showing Flow button resized and repositioned on the report.

  2. After you’ve reviewed the instructions, resize the button and place it where you’d like on the report.

Change the environment in which your flow is created

To select your preferred environment for creating your flow, use the environment picker in the Power Automate visual. This includes environments where you have any built-in security role, as well as any environments where you are a co-owner of one or more flows. If you cannot find your preferred environment, see the article Troubleshoot missing environments to learn more about the requirements.

Screenshot showing selecting a different environment.

Edit the flow

  1. With the flow selected, add any data fields to the Power Automate Data region, to be used as dynamic inputs to the flow.

    Screenshot shows control to add any fields you want as dynamic inputs.

  2. Select More options (...) > Edit to configure the button.

    Screenshot shows select Edit to edit the flow.

  1. In edit mode of the visual, either select an existing flow to apply to the button, or create a new flow to be applied to the button.

    Screenshot shows Create a flow for a SharePoint list in Power B I.

  2. You can start from scratch or start with one of the built-in templates as an example. To start from scratch, select New > Instant cloud flow.

    Screenshot shows New Instant cloud flow.

  3. Select New step.

    Screenshot shows start creating a flow from scratch.

  4. Here, you can choose a subsequent action or specify a Control if you want to specify additional logic to determine the subsequent action.

    Screenshot shows choose actions for the flow.

  5. Optionally, you can reference the data field(s) as dynamic content if you want the flow to be data contextual. This example uses the Region data field to create an item in a SharePoint list. Based on the end-user’s selection, Region could have multiple values or just one.

    Screenshot shows Add dynamic content for the flow.

  6. After you’ve configured your flow logic, name the flow, and select Save.

    Screenshot shows Save the flow.

  7. Select the arrow button to go to the Details page of the flow you just created.

    Screenshot shows Navigate to the Details page for the flow.

    Here's the Details page for a saved flow.

    Screenshot shows the Details page for a saved flow.

  8. Select the Apply button to attach the flow you’ve created to your button.

Format the flow

Optionally, you can change the button text, font color, font size, or fill color of the button. These options along with other settings are available in the Format pane:

Screenshot shows Format the flow.

Test the flow

After you've applied a flow to the button, we recommend testing it before you share the flow with others. These Power BI flows can only run in the context of a Power BI report. You can't run these flows in a Power Automate web app or elsewhere.

If your flow is data contextual, make sure you test how the filter selections in the report impact the flow outcome.

  1. To test the flow in edit mode of the report, select Back to report, then press Ctrl while you select the button to run the flow.

    Screenshot shows Select the Run flow button.

    The button text indicates that the flow has been triggered.

  2. To check if the flow has run successfully, select the More commands (...) menu > Details in the flow that has been triggered:

    Screenshot shows Select Details on the More options menu.

  3. On the Details page, you can see the run history and status for the flow:

    Screenshot shows See the run history on the Details page.

Important

You can only run these Power BI flows within the context of a Power BI report. You can't start flows from the Power Automate portal. To test the flow in edit mode of the report, select Back to report, and then press Ctrl + click on the button to run the flow in the context of the report. You can also navigate to edit mode or to Power Automate to view the run history of the flow and ensure it is running successfully.

Share the flow

When the flow is running successfully, you can share it with your report readers.

  1. Select Edit in the Run only users section:

    Screenshot shows Run only users.

  2. Specify which users or groups you want to give run access to:

    Screenshot shows Manage run-only permissions.

Give users edit access

Alternatively, you can give any users edit access to the flow, not just run permissions.

  • Select Share , and specify the users or groups that you want to add as an owner:

    Screenshot shows Share flow ownership with others.

Considerations and limitations

  • Additional manual inputs to the button aren't supported.
  • The visual isn't supported for embedded analytics.
  • The visual doesn't work in Publish to Web (public) scenarios, because unauthenticated scenarios aren't supported by Power Automate.
  • The visual doesn't support export scenarios.
  • The Power Automate visual is limited to process a maximum of 1000 records.
  • The user running the flow within the Power BI report needs to have permissions to run the flow. Grant these permissions through direct sharing by the user or by sharing to a Microsoft Entra group.
  • Create flows that you will use with the Power BI button trigger directly within the Power BI report. Avoid going directly to Power Automate to create these flows, as the trigger will not have access to the data fields necessary for creating the flow.
  • Power BI data is sent to, and processed in, a geography where the flow is deployed.

Related content

For more information about Power Automate, take a look at the following articles: