Restrict scheduling of refresh

[Admin24]

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.

[v-jianpeng-msft]

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

[Admin24]

Done! Cheers Jianpeng

[v-jianpeng-msft]

Thank you very much! 

[Admin24]

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 · Accepted solution]

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,

[Admin24]

Thanks again Ibarrau!

[ibarrau]

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,