Static table Vs dinamic table

Hi, gomezc73 

Incremental Refresh is the process of loading only part of the data that might change, and adding it to the previous dataset which is not changing anymore.

Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data.
With incremental refresh, the service dynamically partitions and separates data that needs to be refreshed frequently from data that can be refreshed less frequently. 

Refer:
Incremental refresh and real-time data for datasets

Configure incremental refresh and real-time data

More:
https://www.sqlshack.com/an-overview-of-power-bi-incremental-refresh/

https://biinsight.com/implementing-incremental-refresh-in-power-bi-part-1/

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

Best Regards,
Community Support Team _ Zeon Zheng

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