Forum Discussion

JibinSebastian's avatar
JibinSebastian
Icon for Advocate II rankAdvocate II
4 months ago
Solved

Scheduling a Microsoft Fabric Pipeline with Specific Time Intervals

I would like to configure a Microsoft Fabric pipeline to run on a recurring schedule with the following requirements: Execute every 10 minutes Start time: 7:10 AM EST End time: 6:50 PM EST Frequ...
  • deborshi_nag's avatar
    deborshi_nag
    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 only

    Pipeline 1 – Data ingestion (trigger if parent Notebook passes as True)
    Copy Data

    Pipeline 2 – Semantic model refresh (runs after pipeline 1 success, engine may skip or throttle if run within 30 mins)
    Semantic model refresh activity

     

    Schedule as discussed in previous post:

    • Frequency: every 10 minutes
    • Time window: 07:10–18:50
    • Time zone: EST