top of page

Search


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

DataZoe
Jan 30, 20214 min read
264 views
0 comments


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...

DataZoe
Nov 2, 20201 min read
217 views
0 comments


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...

DataZoe
Oct 27, 20201 min read
192 views
0 comments
bottom of page