Using Monkey Tools - Analyze Power Query Performance & Refresh Times in Excel!
You hit the Data - Refresh All button, and your Power Queries refresh. Yes, it feels slow, but WHICH query is causing the majority of the latency? Guess what... our Time Sleuth monkey's entire reason for living is to help you figure that out!
Collecting refresh times is only part of the performance analysis story. That just provides data. The Time Sleuth monkey turns that DATA into INFORMATION, providing you with charts to interpret your refresh times. It performs multiple refreshes recording all of the results and can be used to compare things like:
-The performance of different queries in the workbook.
-The effects of privacy settings on your refresh times
-The effects of load destination choices on your refresh times
-The performance of similar queries against each other
In this video Ken takes a deep dive into the Time Sleuth and shows how he used the Time Sleuth to confirm that a users data pattern was superior to one that he actually published in a book. If performance is a concern in your queries, you're going to want this Monkey on your team!