Forum Discussion
Incremental refresh -Detect Data Change column vs Partition Column
hi, Anonymous
RangeStart and RangeEnd parameters
For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters are used to filter the data imported into Power BI Desktop, and also to dynamically partition the data into ranges once published to the Power BI service. The parameter values are substituted by the service to filter for each partition. Once published, the parameter values are overridden automatically by the Power BI service. There's no need to set them in dataset settings in the service. Once published, the parameter values are overridden automatically by the Power BI service.
For your case, you need to set the RangeStart and RangeEnd parameters for process date/time column, and then use auditing date/time column for "Detect Data Changes".
here are documents for you refer to:
https://www.nabler.com/articles/Power-BI-data-refresh-and-scheduling-3.asp
Best Regards,
Lin
Hi,
Thank you for the reply. The issue is that my main fact table only has the process date/time column - this is the audting column which is updated in SQL each time the data is loaded. I do not have any other date/time columns in the fact table. I believe I should use this as the Detect Data Changes column, since it will always have a single date of the last load, but I do not have any other date time column to use for RangeStart and RangeEnd. How do I handle this situation? The documentation says not to use the process date/time column for both.
Mark