Send a email notification from shared mailbox post dataset refresh

[Anonymous]

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 report works fine, but it does not take the customized sender email address from shared email box. The email tha t we receive from subscription is from Micorsoft Power BI as sender.

So next option I was evaluating power automate for the same as it has got lot of email sending options. I have set 2 steps. 

Step 1 - Refresh a dataset

Step 2- Send notification

But when I run the power automate flow, it runs the notification email irrespective of dataset refresh is success or failure.

Is there any option to send a notification email to users from shared mailbox post successful dataset refresh.

Thanks,

Pallavi

[lbendlin · Accepted solution]

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.