Forum Discussion
Incremental Refresh based on loaded date or a custom column
Community Supporthi, Anonymous
For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd.
Since your data set does not have a date in it, It difficult to filter your dataset.
and In a month, you will get a new file that I want to add to the dataset. So i recommend you use get data from the folder,
Then use file attributes(e.g. date Modified/ Date created ) as the date filter.
Here is a post for you as reference:
Best Regards,
Lin
Thank you.
I Tried doing that, but the incremental refresh still did not work.
I was able to bring in the file attributes - date created, and then set up an incremental refresh on that column.
I loaded the data into my model, and published it.
To test it, I chnaged the data in an old file (that has a created date outside the incremental refresh settings), and then I refreshed the dataset.
The old data still refreshed.
Am I missing something or doing something wrong?
- v-lili6-msft
hi, Anonymous
Do you have all the right Settings for it? you may refer to these articles
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
https://powerbi.microsoft.com/en-us/blog/incremental-refresh-in-power-bi-premium/
https://community.powerbi.com/t5/Desktop/unable-to-setup-incremental-refresh/td-p/511554
Best Regards,
Lin