Forum Discussion
Incremental refresh understanding
Hai, as a newbie looking for some understanding of incremental refresh. Read about it, watched a video, but want some confirmation. We have fact tables and dimensions. In our coming architecture...
Hi Anonymous ,
The following requirements need to be satisfied if need incremental refresh to work:
- The data source must support “query folding”
- The filter only applies to date time column
When you can enable the option "Detect Data Changes" and choose the field Last-Changed-Date, then the process of incremental refresh can monitor this field, and only get rows that the date/time is after the latest date/time in this field in the previous refresh. You can review the contents in the following links for more details.
All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only
Power BI Incremental Refresh - Understanding Detect Data Changes
Best Regards
Rena