cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bBI
Frequent Visitor

: Power Automate flow that sends mail AFTER power bi refreshes

Got a simple flow set up:

 

1. Data appears in sharepoint folder

2. Power BI refresh iniated

3. Delay 15 minutes (this is to give PBI time to refresh)

4. Send mail to users

 

Today I received some complaints because the mail went out while the data hadn't been refreshed yet (i.e. people received the mail to soon)

 

Is there a way to replace step 3 by a step that checks for "received confirmation refresh ended successfully"?

3 REPLIES 3
rahulstomar08
Frequent Visitor

hi @lbendlin 

can you please elaborate on your point?

How can we use REST API in power automate to send email 'AFTER' our data gets refreshed.I have used this flowI have used this flow

Not sure how much more there is to say - call the API I mentioned (for example every five minutes) until the top entry of the resulting JSON has an "endTime'  value and a status that (hopefully) says "success".

 

This is different from dataflows where Power Automate can actually be triggered by a dataflow refresh completion directly.

lbendlin
Super User
Super User

Absolutely.  In Power Automate periodically poll the Power BI API to inquire about the dataset refresh status.

 

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory  

(or the premium equivalent)

 

The refresh is complete when the first returned entry has an endTime value and a status other than "unknown"

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors