Forum Discussion
Refresh dataset with API and failure notification
Sorry for long response
I'm not interested in notification in case of completion. I'm interested in notification in case of failure.
Here is the code that i execute.
Here is refresh log of dataset
It has failed. But i have no notification
Try
-Body (ConvertTo-Json @($request))
- lbendlin4 years agoSuper User
My contacts say the same thing - when you use a service principal to request the refresh no communication will be sent out at all.
Not sure if this is a bug or a feature. If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
- Anonymous4 years agoNot applicable
Thanks for your response.
That didn't help
Here is the request code:
Here is the refresh log:
Regards,
Daniil.
- lbendlin4 years agoSuper User
can you try with MailOnCompletion for another dataset that refreshes successfully?
- Anonymous4 years agoNot applicable
It works in absolutely same way as MailOnFailure. There is no notification in my inbox.
- lbendlin4 years agoSuper User
Check your spam folders. Let another developer try on their dataset. Check with your email admin for blockages etc.
- Anonymous4 years agoNot applicable
There is everything fine with mail.
Most probably i don't have email delivered because service user for execution of API requests has been created with Active Directory, not with https://dev.powerbi.com/Apps
Even if i create user with https://dev.powerbi.com/Apps, the only one user, who created service principal will know, that there is something wrong with refresh, not the dataset owner.
So for now this feature is not mature enough to refresh datasets in real world.
Regards,
Daniil.
- lbendlin4 years agoSuper User
I don't think you had mentioned that you are using a service principal for the refresh request. I'll check with our developers that use a similar setup.
- lbendlin4 years agoSuper User
try this:
$request = @{
"notifyOption" = "MailOnFailure"
}
- GdBreems4 years agoFrequent Visitor
lbendlin Any luck on this? I'm calling a refresh request using a service principal. Request is called from Azure Data Factory pipeline using a webactivity with the following setting:
No mail is received by the Owner or any additional contacts specified in powerBI scheduled refresh. Refresh of the dataset is completed correctly.
- GdBreems4 years agoFrequent Visitor
Thank you for your response, too bad it doesn't work at this moment in time.
I will probably be raising a ticket and hope for change!