cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deaconb Frequent Visitor
Frequent Visitor

Help using Buffer command

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!

Query for Curriculum Data.pngQuery for Documents for Deletion.pngQuery for Effective Documents.png

1 REPLY 1
Community Support Team
Community Support Team

Re: Help using Buffer command

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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 185 members 1,907 guests
Please welcome our newest community members: