Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

"Unbuffer" - List/Table

Hey everyone,   I have a question regarding the Buffer() function in M. So after loading a List or Table into memory, is there away to unload it after it is not required anymore? That would be pote...
General Comment
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    After my tests and research, I don't find a way like "unbuffer" to release memory manually.

    When Power Query run the above query, it will actually takes memory, but after the data imported into dataset, Power Query will release this part of memory. 

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

After my tests and research, I don't find a way like "unbuffer" to release memory manually.

When Power Query run the above query, it will actually takes memory, but after the data imported into dataset, Power Query will release this part of memory. 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-eachen-msft , 

 

thank you for the reply. Ok, understood - that answers it.

 

Yes my idea was to release the list from memory in my case to free up memory for the subsequent transformation steps of the query to potentially increase the query execution performance. 

 

Best regards,

Christian