Forum Discussion

Siboska's avatar
Siboska
Helper II
3 years ago
Solved

Looking for incremental refresh advise

Hi,  I would like to get some suggestions (Articles, links, advise, e.g.) on how I can approach my incremental refresh setup in Power BI.  Case: I have historical project data which consist of...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    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.

Siboska's avatar
Siboska
Helper II
3 years ago

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?

edhans's avatar
edhans
Community Champion
3 years ago

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.