instead of Table.Buffer In Query

Hi mgomaa07 

Table.Buffer loads the entire table's data into memory for cases where you need to access the same data multiple times, if you don't need to buffer the data and just want to prevent downstream folding, use Table.StopFolding instead. 

Regarding refresh, you can set parameters in the query to load only data for a specific time range or condition. For example, you can use a date parameter to refresh data only for a specific time period.

Table.Buffer - PowerQuery M | Microsoft Learn

Table.StopFolding - PowerQuery M | Microsoft Learn

Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.