Turn off scheduled refresh failure notification for large number of reports

[h4tt3n]

Hi all,

I have worked with PBI for a couple of years and administrate well over a hundred reports across a two-digit number of workspaces. 

We are currently in the process of moving PBI responsibility to a different department. I am receiving a very large amount of Refresh Failed notifications via mail as a concequence of this process. Is there a way for me to do an automated batch disable of all such notifications across all workspaces and reports, without having to manually disable them one by one?

Best regards,

Mike

[ibarrau · Accepted solution]

Hi. If you have added yourself to the list of people that would receive mails in case of failure, then I think you should do it manually. If you haven't and you are just receiving mails because you are the dataset owner, then you can do something. You could run a python script looping for workspaces and dataset taking ownership of the datasets with the following request of the PowerBi Rest API:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/take-over-in-group

I hope that helps,

[h4tt3n]

hi @ibarrau 

Yes, I already know about the dataset takeover API call and have written a PowerShell script for automatic dataset ownership takeover. Unfortunately, the API endpoint does not allow for ownership removal, so for this to work I would need someone else to run the script.

[ibarrau]

Yes. Just remember you can use a Service Principal for this to take ownership with a service account. That would be the solution that you can run it to change ownership without the need of asking other user to run it. That would be the only way to get you out of the mail automatically for now.

Regards,