Trigger Dataflows and Power BI Datasets Sequentially

Introduction

There are two common scenarios for how you can use this connector to trigger multiple dataflows and Power BI datasets sequentially.

  1. Trigger the refresh of a standard dataflow after the successful completion of an analytical dataflow refresh.

If a dataflow performs all actions, then it is hard to reuse its entities in other dataflows or for other purposes. The best dataflows to reuse are dataflows doing only a few actions, specializing in one specific task. If you have a set of dataflows as staging dataflows, and their only action is to extract data "as is" from the source system, these dataflows can be reused in multiple other dataflows. For more information, see the best practices for reusing dataflows.

  1. Trigger the refresh of a Power BI dataset when a dataflow refresh completes successfully.

If you want to ensure that your dashboard is up to date after a dataflow refreshes your data, you can use the connector to trigger the refresh of a Power BI dataset after your dataflow refreshes successfully.

Trigger Dataflows Sequentially

This tutorial covers the first scenario above.

  • Navigate to Power Automate.
  • Search for the template "Trigger a dataflow refresh after my dataflow refresh completed successfully". If you encounter difficulty, follow these instructions.

overview of simultaneous dataflow

  • Customize the flow. Actions that require input from you will automatically be expanded.

    The Dataflow Refresh trigger is expanded because you need to enter information on your dataflow:

    • Group Type: Select Environment when connecting to Power Apps and Workspace when connecting to Power BI.
    • Group: Select the Power Apps environment or the Power BI workspace your dataflow is in.
    • Dataflow: Select your dataflow by name.

    After the condition, you can specify what happens after success or failure of the dataflow. In this template, we trigger a new dataflow:

    The Refresh a dataflow action is expanded because you need to enter information on your dataflow:

    • Group Type: Select Environment when connecting to Power Apps and Workspace when connecting to Power BI.
    • Group: Select the Power Apps environment or the Power BI workspace your dataflow is in.
    • Dataflow: Select your dataflow by name.