Forum Discussion
Looking for incremental refresh advise
I would advise creating a column called "Snapshot Generated Date" that is a DateTime field, then use that field for the RangeStart/RangeEnd parameters.
That way, if someone generates one for Jan 1, 2022 today, it will be 9/20/2022 and will be within the current refresh range, but by Oct 21, it will fall out and move to the first historical partition.
I would advise creating a column called "Snapshot Generated Date" that is a DateTime field, then use that field for the RangeStart/RangeEnd parameters.
That way, if someone generates one for Jan 1, 2022 today, it will be 9/20/2022 and will be within the current refresh range, but by Oct 21, it will fall out and move to the first historical partition.
Thanks for your fast reply.
And is it also possible Input RangeStart as dynamically looking 30 days back in time?
Also is it possible to configure incremental load across multiple tables at once or do you need to configure this manually for every relevant table?It is always dynamic. The dates you initially load in are just to get it going. Once you configure the below dialog box, the service ignores the hardcoded dates in the parameters and uses dynamic dates. See Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn for more info.
You would need to configure for each table. The Select Table box below is where you can set different policies for each table.
