DataZoeJan 30, 20214 minWorking with DateID in Direct Query and Incremental RefreshScenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat
DataZoeNov 2, 20201 minCareful with RangeEnd with Incremental RefreshLately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...
DataZoeOct 27, 20201 minDateID compare to DateTime in Power Query for Incremental RefreshIncremental refresh requires a DateTime field and many tables come from the database instead with the DateID column. Here is how to...
