Power Query

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

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

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