Timing a query - duration

[SteveApa]

Hi.  I am trying to set a timer start at the beginning of refresh and timer stop at end of refresh.  How can this be done?  I would like to track, statistically, how long it takes.  Seems like Power Query starts all queries at the same time.  There is definatelly an order in my queries... Query 1 starts and gets criteria to create a where statement for query 2... so query 1 must run first.  But seems like they both start at the same time with query 2 waiting for query 1 to be finished

[v-angzheng-msft · Accepted solution]

Hi, @SteveApa 

With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop. While we'll be expanding on this feature in the future, including adding the ability to use it during full refreshes, at this time you can use it to understand what sort of queries you're emitting, what slowdowns you might run into during authoring refresh, and what kind of background events are happening.

To use Query Diagnostics, go to the Tools tab in the Power Query Editor ribbon.

There's many questions you can try to answer with query diagnostics, but the two that we see the most often are asking how time is spent, and asking what the query sent to the source is. If we want to see how the time is spent, we can just look at the visualizations we built.

Refer:

Query Diagnostics

Visualizing and Interpreting Query Diagnostics in Power BI

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@SteveApa You can set them up to not run in parallel. Couple things. You can use the Tools tab in the Power Query Editor ribbon to start and stop diagnostics. Also, if you schedule the refreshes in the Service, you can view refresh statistics there.