Table.Buffer for sharepoint datasources

Hi Anonymous ,

Table.buffer can optimise the peformance only when a query that needs to be evaluated over and over. You can refer to the list.buffer document:https://blog.crossjoin.co.uk/2015/05/05/improving-power-query-calculation-performance-with-list-buffer/ it works at the same ways.

You did a merge steps between two excel file? You can try to add a primary key on the linked column, it can prevent files to be load into power query multiple times when it merges two queries, please refer to https://blog.crossjoin.co.uk/2018/03/16/improving-the-performance-of-aggregation-after-a-merge-in-power-bi-and-excel-power-query-gettransform/

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

Best Regards,

Dedmon Dai