powerbi rest api creating refresh schedule with notifyoption with service principle profile

[anonymouseke]

Hi all, as the title suggests, when creating a new profile, workspace and report for a multi-tenant environment. PowerBi automatically creates a refresh schedule that looks like this:

{
    "@odata.context": "https://api.powerbi.com/v1.0/myorg/groups/{groupId}/$metadata#Microsoft.PowerBI.ServiceContracts.Api.V1.RefreshSchedule",
    "days": [
        "Sunday",
        "Monday",
        "Tuesday",
        "Wednesday",
        "Thursday",
        "Friday",
        "Saturday"
    ],
    "times": [
        "01:30"
    ],
    "enabled": false,
    "localTimeZoneId": "UTC",
    "notifyOption": "MailOnFailure"
}

We then have some code to automatically disable all refresh schedules since we have our own function app to refresh all datasets. I did however add some extra code to make sure the refresh schedule is always disabled. So I run a patch request to the refresh dataset in group endpoint with this body:

{
    "value": {
        "enabled": false,
    }
}

This request FAILS because the "MailOnFailure" is not valid for a service app owner workspace. 

This seems like an oversight and I want to report this as a bug, as now, we have to first send a request to change the NotifyOption and only after that we can make sure to send the `enabled: false` command.

[v-venuppu]

Hi @anonymouseke ,

We are following up once again regarding your query. Could you please confirm whether the issue has been resolved through your support ticket with Microsoft?

If so, we would appreciate it if you could share the resolution or any key insights here to benefit others in the community. If we don’t receive a response, we will proceed with closing this thread.

If you need further assistance in the future, feel free to start a new thread in the Microsoft Fabric Community Forum. We will be happy to support you there.

Thank you.

[anonymouseke]

Hi @v-venuppu ,

I raised an issue and they are now looking at it internally. Will try update here if they respond that it's fixed!

[v-venuppu]

Hi @anonymouseke ,

Have you had a chance to raise a support ticket and resolve this issue? If so, please consider sharing the solution in the forum and marking it as accepted, this will help other members find the answer more easily.

Thank you.

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .