Forum Discussion

zahlenschubser's avatar
zahlenschubser
Helper IV
3 years ago

Incremental Refresh & Historical Data

I seem to be misunderstanding something about incremental refresh, but I couldn't figure out what.   I managed to set up the paramenters and filtered the table I want to incrementally refresh, set ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi zahlenschubser ,

What's the data source? Which table you configure incremental refresh on? Could you please check and confirm if that table in the underlying data source exist the data which is from 4 years from to "current" data exactly? And you can refer the following official documentations to configure incremental refresh:

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

In Archive data starting, specify the historical store period you want to include in the dataset. All rows with dates in this period will be loaded into the dataset in the service, unless other filters apply.

 

In Incrementally refresh data starting, specify the refresh period. All rows with dates in this period will be refreshed in the dataset each time a manual or scheduled refresh operation is performed by the Power BI service.

Best Regards