cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GregoryMelo
Regular Visitor

Power Query Dataflows trigger

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

 

 

2 REPLIES 2
lbendlin
Power Participant
Power Participant

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.

GregoryMelo
Regular Visitor

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!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,830)