Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @deaconb
Read these articles to learn how to use Buffer function.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |