Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
h4tt3n
Resolver II
Resolver II

Turn off scheduled refresh failure notification for large number of reports

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

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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.

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.