Forum Discussion
Anonymous
3 years agoNot applicable
Dataflow Incremental Refresh - Problems with Excel
I'm currently testing the incremental refresh feature with a dataflow. The dataflow is not complying with the incremental refresh settings and I do not understand why. Below is a minimal working exam...
v-xiaosun-msft
3 years agoCommunity Support
Hi Anonymous ,
After set up the system generates an automated range start resp. range end in the dataflow. This is the problem.
The problem is linked with RangeStart & RangeEnd, 0001.1.1 00:00:00 is not the correct data format.
You can convert it to something like December 30th, 1899, which is the base date for DAX. Or you can set the range manually in the dataflow with "normal" dates dataflow.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.