Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.