Power Query

Jan 30, 20214 min read

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

Nov 2, 20201 min read

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

Oct 27, 20201 min read

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