Setting up incremental refresh for Power BI datasets
Proposed session for SQLBits 2026TL; 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.
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
Speakers
Justin Bird's other proposed sessions for 2026
From manual deployments to automated pipelines - 2026
Getting good at git - 2026
Running Code Clubs - 2026
SQL database projects and the SDK-style project format - 2026