Increment refresh

[Janewhite]

Hi All, First time doing an Increment refresh I'm trying to get the data to load everything from day one, but then only pull the previous day going forward 

so once all the data are imported, tomorrow's refresh should only insert today's data from that field 

what I have done below, will give me what I am trying to accomplish, please 

Thank you all in advance 

[v-yadongf-msft · Accepted solution]

Hi @Janewhite ,

Your current configuration is correct.

As you mentioned "I'm trying to get the data to load everything from day one", after publishing to the service, you perform an initial refresh operation on the dataset. This should be an individual (manual) refresh so you can monitor progress. The initial refresh operation can take quite a while to complete. Partitions must be created, historical data loaded, objects such as relationships and hierarchies are built or rebuilt, and calculated objects are recalculated.

Subsequent refresh operations, either individual or scheduled are much faster because only the incremental refresh partition(s) is refreshed. 

For more information, please refer to: Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.