Forum Discussion
Incremental refresh with no parameters advice
- Hi there
Even though you set it to only go back one day, because it cannot do query folding it has to read all the data to find the last day.
Incremental refreshing is the right approach but it only works on data sources that can do query folding which is typically database systems
Hey tbobolz , sorry for barging in,
I have a very similar requirement - a 'point in time' data that I need to keep adding rather than overwriting upon refresh (in order to create trends).
I couldn't understand if you actually managed to do this using the Incremental Refresh feature.
If you did, I'd be happy if you could elaborate a bit on your solution.
Thanks a lot!
Hi Yaa_D
No this was ot achievable on a csv file, and I moved to doing a simple refresh of the entire data set each day, as it is not that large. Also, I can control my data set through the software I am exporting it from. Sorry, probably not the answer you were looking for.
I do need to try this again on another tool I am developing, but as suggested in this conversation, it does not work with csv files. I'll need to use an SQL export and have IT help me do the initial set-up.
Good luck on your project!