instead of Table.Buffer In Query

[mgomaa07]

please  i  want  to find  Instead of  Table.buffer in query   or   i  want  to  refresh  part of  data  only  without  using  incremental  refresh    

[Anonymous]

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.

[mgomaa07]

hi  thank you  for  replaying  

please  explain  for details  about  refresh  using parameters  (step by step )

[Anonymous]

Hi @mgomaa07 

Please review the following for detailed steps:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Only Get the Last Few Periods of Data into Power BI using Power Query Filtering - RADACAD

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.

[Arul]

@mgomaa07 ,

Your ask is not clear. Can you explain it more in detail?