Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NAOS
Advocate III
Advocate III

Power Query - How to identify slow steps in query.

Hi all,

I would like to know if there is a way to identify which query steps are slowing down the overall refresh time of my queries. I've been doing some reading and suggestions vary a lot, with no clear guidance on how to actually measure and identify slow query steps.

I know join/merge operations will slow down things. I also know from experience that comparing lists with the default List.Difference and similar operations are a burden too. I avoid all of this operations and try to sort the dependencies of the queries so it doesn't call the data source multiple times for different queries. I've tried table / list buffering but Im not sure I fully understand what they do...and I think neiter does the people that recomends their use haha.

Still, some of the queries are really slow. Any suggestions?

Thanks!

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

using Table.Buffer or List.Buffer may help in the scenarios you mentioned
@ImkeF has created nice summary of different M performance tips:
https://www.thebiccountant.com/speedperformance-aspects/

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

using Table.Buffer or List.Buffer may help in the scenarios you mentioned
@ImkeF has created nice summary of different M performance tips:
https://www.thebiccountant.com/speedperformance-aspects/

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Excellent collection of articles. Thanks @Stachu!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.