Load Only the Last N Days of Data in Power Query M

Filters a source to only the most recent N days, to keep refreshes fast during development.

Database & RefreshBeginnerfilterrecent dataperformancedate

Power Query M code

let
    Source = YourTable,
    CutoffDate = Date.AddDays(DateTime.Date(DateTime.LocalNow()), -30),
    FilteredRows = Table.SelectRows(Source, each [DateColumn] >= CutoffDate)
in
    FilteredRows

Generate a date table in Power Query M

Notes

Change -30 to however many days back you want to load; remove this filter before publishing if the report needs full history.

Requirements

A table with a date column.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Load Only the Last N Days of Data.