topic Re: Refresh dataset with API and failure notification in Developer

Refresh dataset with API and failure notification

Anonymous — Tue, 21 Sep 2021 13:26:33 GMT

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.

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 22 Sep 2021 01:09:49 GMT

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

Re: Refresh dataset with API and failure notification

Anonymous — Wed, 22 Sep 2021 08:05:53 GMT

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)

Re: Refresh dataset with API and failure notification

Anonymous — Wed, 22 Sep 2021 08:07:32 GMT

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

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 22 Sep 2021 12:35:57 GMT

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

Re: Refresh dataset with API and failure notification

Anonymous — Wed, 22 Sep 2021 12:51:59 GMT

I am dataset owner. And i recieved nothing

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 22 Sep 2021 13:04:23 GMT

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

Re: Refresh dataset with API and failure notification

Anonymous — Thu, 23 Sep 2021 06:27:38 GMT

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

Re: Refresh dataset with API and failure notification

lbendlin — Thu, 23 Sep 2021 13:45:07 GMT

Try

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

Re: Refresh dataset with API and failure notification

Anonymous — Fri, 24 Sep 2021 07:55:06 GMT

Thanks for your response.

That didn't help

Here is the request code:

Here is the refresh log:

Regards,

Daniil.

Re: Refresh dataset with API and failure notification

lbendlin — Fri, 24 Sep 2021 12:15:55 GMT

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

Re: Refresh dataset with API and failure notification

Anonymous — Wed, 29 Sep 2021 06:57:34 GMT

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

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 29 Sep 2021 10:18:19 GMT

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

Re: Refresh dataset with API and failure notification

Anonymous — Wed, 29 Sep 2021 11:14:46 GMT

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.

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 29 Sep 2021 12:31:56 GMT

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.

Re: Refresh dataset with API and failure notification

lbendlin — Wed, 29 Sep 2021 17:15:15 GMT

try this:

$request = @{

"notifyOption" = "MailOnFailure"

}

Re: Refresh dataset with API and failure notification

GdBreems — Tue, 22 Mar 2022 14:54:24 GMT

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

Re: Refresh dataset with API and failure notification

lbendlin — Tue, 22 Mar 2022 16:20:20 GMT

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/

Re: Refresh dataset with API and failure notification

GdBreems — Wed, 23 Mar 2022 07:42:36 GMT

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!

Re: Refresh dataset with API and failure notification

AnonymousPerson — Tue, 02 Aug 2022 17:18:01 GMT

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.