Forum Discussion
Helper IVIncremental Refresh & Historical Data
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
zahlenschubserThe source is a mysql database with several large tables, so I am trying to shorten the loading times as much as possible, and incremental refresh should help a lot here.
The underlying datasource doesn't have entries that old, but I want to eventually keep that much data archived. The source gets cut off 9 months prior to the current data and I cannot change that, so I need to work around it.
- zahlenschubser
I would really appreciate some assistance here =(