March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
Solved! Go to 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,
Happy to help!
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,
Happy to help!
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,
Happy to help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
27 | |
19 | |
11 | |
8 |
User | Count |
---|---|
55 | |
43 | |
24 | |
13 | |
12 |