DataZoe
Working with DateID in Direct Query and Incremental Refresh
Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat
top of page
Search
DataZoe
- Nov 2, 2020
- 1 min
Careful with RangeEnd with Incremental Refresh
Lately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...
85 views0 comments
DataZoe
- Oct 27, 2020
- 1 min
DateID compare to DateTime in Power Query for Incremental Refresh
Incremental refresh requires a DateTime field and many tables come from the database instead with the DateID column. Here is how to...
108 views0 comments
bottom of page