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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors