Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Dataflow
Need Help
v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your reply, v-xiaosun-msft!

 

I don't understand what you are suggesting. RangeStart and RangeEnd have the correct datatype: DateTime. However, the values of RangeStart and RangeEnd are obviously wrong since they don't correspond to what I entered in the incremental refresh settings (step 3 in my original post). This leads to two questions:

  1. What should the values of RangeStart and RangeEnd be so that they correspond with the incremental refresh settings from step 3 (both "Store rows from the past" and "Refresh rows from the past")?
  2. Is this going to get passed along to an engineer that can fix this internally? This bug should be fixed as soon as possible