Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Send a email notification from shared mailbox post dataset refresh

Dear Power BI Community, I have this special requirement to refresh a dataset and on successful refresh, we need to send email notification to users. Already aware that subscription to email on rep...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    PowerAutomate is an appropriate tool.  You have two options

     

    a) Initiate a standard refresh request  and then poll the refresh history of that dataset in reasonable intervals (not more frequently than every five minutes) until the End Date of the latest history entry is no longer undefined.  Then check the status and send email if successful

    b) write your own custom connector, initiate an enhanced API refresh request, collect the request ID and do the above polling based on that request ID.

lbendlin's avatar
lbendlin
Super User
3 years ago

PowerAutomate is an appropriate tool.  You have two options

 

a) Initiate a standard refresh request  and then poll the refresh history of that dataset in reasonable intervals (not more frequently than every five minutes) until the End Date of the latest history entry is no longer undefined.  Then check the status and send email if successful

b) write your own custom connector, initiate an enhanced API refresh request, collect the request ID and do the above polling based on that request ID.