Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Trigger Automatically the dataset refresh after dataflow refresh is done

  • 1.  Trigger Automatically the dataset refresh after dataflow refresh is done

    Posted 13 days ago
    Hello Everyone,
                      Anyone have experience automating the process to refresh the dataset after the dataflow refresh is completed.   Does Power BI offers an option to doing so?
                      Currently we have both scheduled at specific times of the day, but we would like to trigger the refresh as soon as dataflow refresh is done.


    ------------------------------
    Jonathan Quesada
    Power BI Costa Rica
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Trigger Automatically the dataset refresh after dataflow refresh is done

    Bronze Contributor
    Posted 13 days ago
    Hey Jonathan,

    I'd be curious as well for any solution someone has. A workaround I used was to use Power Automate. We had a dataflow refresh that took anywhere from 25-35 minutes starting at 7am. Because of that unusual time, we couldn't assume that it would be done by 730am. So we scheduled the dataset refresh for the 7:40am using a Power Automate flow.

    ------------------------------
    Gregory Bounds
    Ironedge Group
    TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Trigger Automatically the dataset refresh after dataflow refresh is done

    Posted 12 days ago
    Yes @Gregory Bounds we do the same with scheduled refreshes in the service, but we would like to understand if there is kind of an event trigger available we can use. ​

    ------------------------------
    Jonathan quesada
    10905
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Trigger Automatically the dataset refresh after dataflow refresh is done

    Top Contributor
    Posted 12 days ago
    I hope this question will be obsolete once direct query connections to dataflows will be available.

    ------------------------------
    Lutz
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Trigger Automatically the dataset refresh after dataflow refresh is done

    Posted 11 days ago
    Hi Jonathan,
    As @Gregory Bounds said you can use power flows. This is a workaround including power flows and API. Trigger first the desired dataflow using the API. The response will give you a 200 but i don't think this means that refresh was completed. so you enable the option MailOnCompletion
    MailOnCompletion
    • string

    Mail notification will be sent on refresh completion, including either failure and success

    This option will generate an email and you should be able to create a flow which reads that email and trigger the dataset refresh(This option is available on Flow)
    https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow


    ------------------------------
    Jorge Sanchez
    33018
    Beauchamp Construction Co , Inc
    Miami FL
    3058634762
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Trigger Automatically the dataset refresh after dataflow refresh is done

    Bronze Contributor
    Posted 2 days ago
    Ingenious solution @Jorge Sanchez​. Another reason for me to revisit the Power BI API.

    ------------------------------
    Gregory Bounds
    Ironedge Group
    TX
    ------------------------------

    Academy - Online Interactive Learning from Experts