Forum Discussion
PowerBI refresh issue.
Hi Vasudevan606,
The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.
Improving Power Query Calculation Performance With List.Buffer()
Optimising The Performance Of Power Query Merges In Power BI
I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Vasudevan606,
The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.
Improving Power Query Calculation Performance With List.Buffer()
Optimising The Performance Of Power Query Merges In Power BI
I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng