Forum Discussion
Power BI Scheduled Refresh – Different Timings for Specific Days
- 4 months ago
Hi MFelix ,
Finally by adding my user in to the Active directory group which is given access to Create fabric items under Admin portal "Users can create fabric items" I'm able to create the pipeline.
Now I have created a pipeline and added 2 schedules for the same pipeline one is for monday and I schedule is for other days. Just take a look at it and let me know if it works.
Regards,
Kishor
- 4 months ago
Hi Ramkishor ,
The permission made sense, I assumed that you were already part of the Creators in Fabric.
The setup looks correct now you just need to monitor, may I sugged to add a new activity to your pipeline to send you a message trough email or a teams message when it runs that way you may have notification about if it's running properly without need to go into the service.
Don't forget to accept the correct answer so it can help other even if it is yours.
Hi Ramkishor ,
To my information using the schedulle refresh you cannot set different for each day you have two main options daily where you can setup the time(s) that you want the refresh or weekly but even for weekly you can only set the time for the days select to always be the same.
One option that you can check is to set up a Power Automate flow
https://www.youtube.com/watch?v=IU1oLy7P-TU
https://www.youtube.com/watch?v=lbYDk9KxHEg
If you are on Fabric capacity then you can create a Pipeline that would allow you to do this type of schedulling since an option there is the refresh of semantic models.
https://powerbi.microsoft.com/pt-pt/blog/semantic-model-refresh-templates-in-power-bi-preview/