Forum Discussion
Scheduling a Microsoft Fabric Pipeline with Specific Time Intervals
- 4 months ago
Hello JibinSebastian
I am assuming your Fabric capacity is paused outside business hours (7AM - 7PM) to save costs. If you set your pipeline to trigger every 10 mins, the trigger will run fine but your pipeline will fail because your capacity is found Paused.
Secondly, Power BI semantic model enforces a 30 min minimum interval window, so the service backend will block it, regardless we tried a 10 min interval. Maximum 8 scheduled refreshes per day per dataset is allowed.
Considering the above, I suggest you design it the following way:
Orchestrator pipeline
Notebook activity (checks against weekends)
Scheduled every 10 minutes, business hours onlyPipeline 1 – Data ingestion (trigger if parent Notebook passes as True)
Copy DataPipeline 2 – Semantic model refresh (runs after pipeline 1 success, engine may skip or throttle if run within 30 mins)
Semantic model refresh activitySchedule as discussed in previous post:
- Frequency: every 10 minutes
- Time window: 07:10–18:50
- Time zone: EST
Hi JibinSebastian,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Kagiyama_yutaka, lbendlin, lbendlin, deborshi_nag, for those inputs on this thread.
Has your issue been resolved? If the response provided by the community member Kagiyama_yutaka, lbendlin, lbendlin, deborshi_nag, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.