Forum Discussion
trigger dataflow/datapipeline monthly
Hey there,
I am trying to do a monthly trigger for my dataflow and datapipeline. The options only show every minute/hour/day/week, but in this scenario I would like to do a snapshop on the 1st every month.
I thought about running it daily and adding an if-condition to my dataflow to check whether it is the first of the month before running the rest of the flow. But that seems more like a workaround to me. Do you guys know of any better options?
Hi PhilippM
Thanks for using Fabric Community.
Unfortunately, Microsoft Fabric does not provide a direct option to schedule a monthly trigger. But this trigger is in plan. There is no ETA available yet.
You can refer to this thread for more information:
Re: Best way to set monthly job for data pipeline ... - Microsoft Fabric Community
Hope this helps. Please let me know if you have any further questions.
3 Replies
Hi PhilippM
Thanks for using Fabric Community.
Unfortunately, Microsoft Fabric does not provide a direct option to schedule a monthly trigger. But this trigger is in plan. There is no ETA available yet.
You can refer to this thread for more information:
Re: Best way to set monthly job for data pipeline ... - Microsoft Fabric Community
Hope this helps. Please let me know if you have any further questions.Hey Anonymous,
thank you for the quick reply and sharing the link. Good to know that it is in plan!
Since there is no inbuilt solution I will share my workaround as well, if anybody else needs it. It is just an if-condition with the formula @equals(dayOfMonth(utcNow()),1)
Thanks for sharing your work around and contributing to Fabric Community PhilippM
Please continue using Fabric Community for any help regarding your queries.
