Timer to count how much time it takes to refresh a particular Power Query table

[albertan]

I appreciate if somebody can provide me an idea on how I can have a timer in MS Excel workbook which would count how much time it took to:

1) refresh all Power Query Tables in the Workbook
2) refresh any particular Power Query Table in the Workbook

I will keep researching as well. Thank you

 

[alansidman]

See if this is helpful

Chris Webb's BI Blog: Timing Power Query Queries

If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. It’s not as easy as it seems to adapt your query to …

blog.crossjoin.co.uk

 

[Ken Puls]

Sorry for the late reply on this. My Monkey Tools add-in does this. It is a pro license feature, but is fully functional in the trial period as well.