: Power Automate flow that sends mail AFTER power bi refreshes

[bBI]

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"?

[lbendlin]

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"