22-25 April 2026

Setting up incremental refresh for Power BI datasets

Proposed session for SQLBits 2026

TL; DR

Optimise large Power BI datasets with incremental refresh. Learn setup, best practices, and how to handle deletions using Tabular Editor.

Session Details

Power BI datasets can grow large quickly, and refreshing millions of rows daily becomes increasingly time-consuming and resource-intensive. Incremental Refreshes is a powerful feature that allows you to refresh only the data that has changed, significantly improving refresh performance and efficiency.

This session explores how the feature works, and how to implement it effectively. Through practical demonstrations using Tabular Editor, you'll learn the step-by-step process of configuring incremental refresh policies, including setting up the required parameters, defining refresh and archive ranges, and understanding partition management.

We'll also look at an approach to handling incremental refresh when your source data includes deletions and updates. Whether you're managing large-scale enterprise datasets or simply looking to optimise your Power BI solution, this talk will give you the practical knowledge to implement incremental refresh successfully.

3 things you'll get out of this session

Understand how incremental refresh works and when to apply it to optimize large datasets Configure incremental refresh policies using Tabular Editor with proper parameters and ranges Implement patterns to handle deletions and updates within incremental refresh scenarios