Forum Discussion
Incremental Refresh Initial Load Filtering
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 ?
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
1 Reply
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