Speeding up power query (Table.Buffer?)

Question

Hi,&nbsp;I have an excel file (called GOLDEN_ID) which contains information about the products that we purchase e.g. it contains a taxonomy.&nbsp;The file itself is about 13MB.&nbsp;The file is loaded into the power query, and merged with many other queries.&nbsp;When refreshing the dataset, 1GB&nbsp;is loaded from GOLDEN_ID.&nbsp;This takes forever.&nbsp;Is there any way that I can speed this up? I have read&nbsp;https://www.thebiccountant.com/speedperformance-aspects/which suggests that Table.Buffer might be able to help, but I can't find much documentation on it and I don't know where to appy it.&nbsp;Thanks.&nbsp;

v-juanli-msft · Answer

Hi&nbsp;jhd&nbsp;
When you connect data to Power BI, It would generate a M query connection, you could find M query by&nbsp;opening Advanced editor in Edit&nbsp;Queries where you&nbsp;could use&nbsp;Table.Buffer in the M code.
Reference:
Improving Power Query Calculation Performance With&nbsp;List.Buffer()
Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue
Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query
&nbsp;
Best Regards
Maggie
&nbsp;
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Speeding up power query (Table.Buffer?)

1 Reply

Related content

When to use Table.Buffer

Tips on speeding up Table.NestedJoin

Using Table.Buffer

Power Query SharePoint Connections Refresh Speeds

How do I use table.buffer to speed up a query? (How do I create M code for table.buffer?)