Forum Discussion
Memory Consumtion & Power Query Processing (time)
Hello, I would like to know if someone face the same issue as me. Recently I´ve created a PBI file in which I do some ETL on the Power Query, the applied steps are basically replace values, pivo...
HI BrunaSeixas,
As I said, invoke or refer other steps in query edit may caused additional memory cost(row count * referenced part records) on reference data when you apply change to data view.
For this scenario, I'd like to suggest you use Buffer functions to move reference part to memory to reduce memory consumption.
Regards,
Xiaoxin Sheng
Hi,
Sorry for the late reply, but we did that and it did not seem to work so well. We decide to make our ETL using the Power Query on excel and it processed much better.
Thank you for the help anyway.
KR,