Refresh dataset with API and failure notification

[Anonymous]

Hello.

I'm setting up execution of Power BI report refreshes with API calls.

Everything is fine, but one thing.

I can not understand who is the recipient of failure notification when i set notifyOption to MailOnFailure.

How to customize email address for delivery of such notifications?

Thanks in advance.

Regards,

Daniil.

[AnonymousPerson]

Has there been any update on this since March 2022?

I am using a service principal to refresh a dataset with an API call, and never got anything when it failed.

[lbendlin]

In the Power BI service, in the Dataset settings. There you can specify the recipients.

[Anonymous]

Or you mean some API endpoint that allows to set this setting?

[lbendlin]

Looks like only the dataset owner gets notified for API initiated refreshes.

[Anonymous]

I am dataset owner. And i recieved nothing

[lbendlin]

I tested it on my side and did receive the email.  Did you specify "MailOnCompletion"  ?

[Anonymous]

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

[lbendlin]

Try

-Body (ConvertTo-Json @($request))

[Anonymous]

Thanks for your response.

That didn't help

Here is the request code:

Here is the refresh log:

Regards,

Daniil.

[lbendlin]

can you try with MailOnCompletion for another dataset that refreshes successfully?

[Anonymous]

It works in absolutely same way as MailOnFailure. There is no notification in my inbox.

[lbendlin]

Check your spam folders. Let another developer try on their dataset. Check with your email admin for blockages etc.

[Anonymous]

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.

[lbendlin]

try this:

$request = @{

"notifyOption" = "MailOnFailure"

}

[lbendlin]

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.

[GdBreems]

@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.

[lbendlin]

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/

[GdBreems]

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!

[Anonymous]

Thanks for your response.

Those recipients are used only in case of scheduled refreshes

Here how it looks:

And here how refresh log looks

No messages were delivered to Me (Terentyev Daniil)