Forum Discussion
Solved
Dataflow Incremental Refresh on integer datetime, no GUI option available
I am attempting to set up a dataflow from a source that does not have native datetime values -- instead, the data sources have integer values for date and time. I followed the guide at ( https://lear...
I was able to get around this issue.
1) Load your data into the dataflow
2) Create a dummy datetime column. This will break query folding for now but that's okay
3) Save and close the dataflow. Set up your incremental refresh policy using the dummy.
4) Go back into the dataflow. Delete your dummy variable and set up the incremental refresh with the integer column. Query folding should start working again
Whatever works for you will be fine.
You are missing the point of a dataflow slighty though. The point of a dataflow is to shield you (the developer) from a slow data source. Your SQL server is likely not slow. You would be better off using datasets.