Forum Discussion
Incremental refresh Setup with week start date column in fact table
Hi All, I have a fact table with Sales_week_start_date with date/time data type. I have the below sample data Sales_week Sales_week_start_date 202449 12\01\2024 202450 12\08\...
lbendlin
Super User
Super UserIncremental 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.