Power BI Incremental refresh made simple.
summary
Step‑by‑step shows how to configure incremental refresh for Dataflows and Datasets using Power BI (Pro or Premium Per User), a sample SQL Server with two tables, and scripts on GitHub; stores 2 years of data and refreshes the last 14 days as the rolling window, then demonstrates inserting, updating and deleting rows inside the refresh window (those changes are picked up) while archive rows are static unless using a soft‑delete plus AdjustedDate with detect data changes; explores XMLA endpoint + partitions via SSMS and confirms the pattern works.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 6:01Why incremental refresh
- 9:11The rolling window
- 12:05Experiment preparation
- 15:51Setting up the data flow
- 21:40Configuring the data set
- 28:07Creating thin reports
- 30:33Running the experiment
- 35:15Advanced data changes
- 39:42Soft delete patterns
- 42:12Bonus: Exploring partitions
- 46:33Conclusion and Q&A
