Help using Buffer command

[deaconb]

Hi everyone,

I have three queries which stem from two raw data worksheets. The total number of rows from the raw data worksheets is about 15,000 and the three queries produce is about 10,000 rows of total data. It's currently taking about 30 minutes for each query to refresh (I don't run the queries in parallel) which isn't an exorbitantly long time, but I think it could be faster based on my research of using either the List.Buffer or the Table.Buffer command.

I'm fairly new to power query so I'm hoping some one with more experience with the Buffer command can recommend where to place it within the my three queries. I've attached pictures of the queries to this thread. Additionally, if you have any recommendations of other changes I should make to my queries, I'm open to that information!

Thanks in advance!

[v-juanli-msft]

Hi @deaconb 

Read these articles to learn how to use Buffer function.

Speeding up power query

Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query

Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue

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.