Forum Discussion

jhd's avatar
jhd
Icon for Helper I rankHelper I
7 years ago

Speeding up power query (Table.Buffer?)

Hi,   I have an excel file (called GOLDEN_ID) which contains information about the products that we purchase e.g. it contains a taxonomy.   The file itself is about 13MB.   The file is loaded i...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi jhd 

When you connect data to Power BI, It would generate a M query connection, you could find M query by opening Advanced editor in Edit Queries where you could use Table.Buffer in the M code.

Reference:

Improving Power Query Calculation Performance With 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

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.