Forum Discussion
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
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
The two excel files are located in two different folders in the same sharepoint site. I have performed the merge on two columns form both the excel files - Project Name and Project ID from both the datasets
Another question on this would be where to place the Table.Buffer step ? Would it be right after the merge step? The merge I have performed is "merge as new query"
Hi Anonymous ,
You can put it in your first reference of the table before the merge steps like create a step
source1 = table.buffer(source1). Then do the merge step.
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