Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community,
We use data pipelines to invoke a series a activities that include script activity, notebook and lookup. We would like to schedule this pipeline to run on a monthly basis but couldn't see that option, the only options available are as below
Has anyone encountered this situation and how did you resolve it?
Thanks,
Chetna
Solved! Go to Solution.
Fabric as of today doesnt support Monthly schedule functionality similar to Azure data factory.
So there can be 2 ways:
1) Schedule it weekly and have a IF activity at the start to chcek whether the trigger day is equivalent to the monthly schedule which you prefer; if yes proceed with the further process or skip and complete the pipeline run
2) Use some other offerings that supports Monthly schedules like Azure data factroy, Logic app etc to either trigger the data pipelines via REST API or to upload a file in blob and enable event trigger (in preview) on the fabric data pipeline
Probably the option to schedule monthly refreshes wasn't available back in June 2024, but it is now in case you still need it.
Fabric as of today doesnt support Monthly schedule functionality similar to Azure data factory.
So there can be 2 ways:
1) Schedule it weekly and have a IF activity at the start to chcek whether the trigger day is equivalent to the monthly schedule which you prefer; if yes proceed with the further process or skip and complete the pipeline run
2) Use some other offerings that supports Monthly schedules like Azure data factroy, Logic app etc to either trigger the data pipelines via REST API or to upload a file in blob and enable event trigger (in preview) on the fabric data pipeline
What Expression needs to write here "Schedule it weekly and have a IF activity at the start to chcek whether the trigger day is equivalent to the monthly schedule which you prefer; if yes proceed with the further process or skip and complete the pipeline run"