Forum Discussion
Incremental refresh Setup with week start date column in fact table
Super UserPlease read through the documentation. It's quite a bit more complex than that.
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Thank you for your response. I have already gone through it. But there they have given example based on a date field which is continuous, we can consider calendar and that dates are in sync.So we can understand it easily. But in my case it is weekly data that too with 1 week delay dates. So I am little bit worrying on this.
- lbendlin
Incremental refresh does not support weekly partitions. Your choices are Day, Month, Quarter and Year.
Use the first day of the week to drive the daily partitions, or use monthly partitions.
Yes. We don't have week option there. But my data gets loaded weekly once at the source, I need to refresh my report weekly.So I have given 7 days. Then what period should I give in the incremental refresh data.