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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
h4tt3n
Helper V
Helper V

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.