web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 6CC2T4uG9GusHddoCO/dqO
Power Automate - Using Flows
Unanswered

Power Query Dataflows trigger

Like (0) ShareShare
ReportReport
Posted on 8 Dec 2022 21:53:09 by 12

Hey guys,

 

I am using Power Automate to trigger a refresh in a Power Query dataflow every 5 minutes. It worked fine; however, the flow did not show when the refresh failed. To improve my control, I added a trigger after the refresh action, "When a dataflow refresh completes," to retrieve the status after the update and let the flow know the result.

 

The dataflow failed today, and I can see this at Power BI Service; however, the information did not come back to Power Automate, and the flow was awaiting until I canceled it. To solve this, I add a parallel timer: if the flow waits more than 5 minutes, it will finish and send a failure message.

 

Have you experienced this situation? What have you done? What do you think about my solution?

 

GregoryMelo_0-1670536308026.png

GregoryMelo_1-1670536326520.png

 

 

  • GregoryMelo Profile Picture
    12 on 11 Dec 2022 at 22:40:57
    Re: Power Query Dataflows trigger

    Thanks for sharing your knowledge with me.

    This dataflow runs every 5 minutes because it ingests data from a real-time API with information about power generation and consumption in Brazil.

     

    I will look at the documentation and make some modifications to my flow.

     

    Thanks again!

  • lbendlin Profile Picture
    8,081 Super User 2025 Season 2 on 10 Dec 2022 at 00:11:34
    Re: Power Query Dataflows trigger

    A dataflow? Every five minutes? That's a red flag. 

     

    Keep in mind that refresh requests are completely asynchronous.  They are only requests. You don't even get a requestid back (as you do with enhanced API dataset refreshes),

     

    You need to run independent asynchronous flows to handle this.  One flow to request refreshes, another flow to be triggered by dataflow refresh completion. In the second flow you get the status back and can decide what to do in either scenario.

     

    Note that a refresh request will be ignored if a refresh is currently in progress.

     

    Note that you can monitor dataflow refreshes via Dataflows - Get Dataflow Transactions - REST API (Power BI Power BI REST APIs) | Microsoft Learn and can also attempt to cancel them.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete