Forum Discussion
Restrict scheduling of refresh
Hi,
Is there a way to limit refresh times for reports deployed to Power BI service? We wish to restrict the time slots available to contributors to ensure the warehouse is not overwhelmed with multiple refresh requests at similar times.
Thank you.
Sure, no problem. As an alternative to build standards for the company and motivate the users to respect them, you can take away that permission. If you are using gateways, keep the permission for admins only. If you are using a cloud source it might be more complex because you can't prevent it easily, you should build a repository to make devs work until there and let an admin or CD configuration to publish and configure refreshes. Those two ways make you owner of all refreshes at the tenant.
I hope that helps,
7 Replies
- ibarrau
Super User
Hi. I don't think there is a way inside Power Bi to prevent the amount of refreshes a user can configure for a dataset. That kind of issues are solved with a good developer culture. Talking about best practices with the team, generating commitment to the standards you can define with good importance explanation. The team should respect the company standards for developing or deploying.
I hope that helps,
Thank you very much for the excellent answer ibarrau
Hi, Admin24
Thank you so much for raising your questions in the community! If Super user's reply solves your doubt, you can mark it as a "solution" so that other friends who encounter similar problems can also find the answer. This will go a long way in helping others in the community. Thank you again for participating!
Best Regards
Jianpeng Li
Done! Cheers Jianpeng
Hi Ibarrau,
I appreciate your prompt response which is very helpful indeed.
I was hoping to only limit the time slots available (as an example allowing for refreshes between 1200 and 1700 only and not when the ETL processes are running). It was configurable in Tableau but as you highlighted not an option in Power BI.
Thanks and enjoy the rest of your day.
- ibarrau
Sure, no problem. As an alternative to build standards for the company and motivate the users to respect them, you can take away that permission. If you are using gateways, keep the permission for admins only. If you are using a cloud source it might be more complex because you can't prevent it easily, you should build a repository to make devs work until there and let an admin or CD configuration to publish and configure refreshes. Those two ways make you owner of all refreshes at the tenant.
I hope that helps,
Thanks again Ibarrau!
