Increment refresh

Hi Anonymous ,

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.