Incremental Refresh Initial Load Filtering

[Puneethg78]

I am doing initial load using RangeStart and RangeEnd date/time parameters for 1 month . However 1 Month data is too big (130M records and 30 columns) to load in Power BI desktop and  errors out. Can we put additional filters on other columns to reduce the number of rows to few 1000's so that the  initial load  is successful and later we discard this filter while doing incremental refresh  in Power BI service ?

[lbendlin · Accepted solution]

yes, that's how it works anyway.  The values you specify in Power Query for RangeStart and RangeEnd are completely ignored when the Power BI service creates and manages the partitions.

Also read about bootstrapping

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn