Forum Discussion
Dataflow Incremental Refresh
According to my understanding, Power BI will load the data that satisfies the SELECT * FROM sales WHERE saledate >='2023-01-01 statement into Power BI. When using incremental refresh, the service will dynamically partition the data and create incremental refresh partitions and historical partitions. In each subsequent refresh, the rows whose date/time is within the refresh cycle will be refreshed. The rows whose date/time is no longer within the refresh cycle will become part of the historical cycle and will not be refreshed again.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
According to my understanding, Power BI will load the data that satisfies the SELECT * FROM sales WHERE saledate >='2023-01-01 statement into Power BI. When using incremental refresh, the service will dynamically partition the data and create incremental refresh partitions and historical partitions. In each subsequent refresh, the rows whose date/time is within the refresh cycle will be refreshed. The rows whose date/time is no longer within the refresh cycle will become part of the historical cycle and will not be refreshed again.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yulia - Thank you for the information. That's very helpful to know.
