M Query Timing

Chris Webb gives a couple of options for timing M queries:

In M, the DateTime.LocalNow() function returns the current system date and time at the time the function is called – which means that you could call it multiple times in the same query and get different results. There’s also the DateTime.FixedLocalNow() function which also returns the system date and time; the difference between the two is, as the documentation says:

This value is fixed and will not change with successive calls, unlike DateTime.LocalNow, which may return different values over the course of execution of an expression.

This is good to know for those query-tuning scenarios.

Related Posts

Diagramming Databases With Power BI

Philip Seamark shows how to visualize the relationships between tables using Power BI: The network navigator was another good visual, and if you have an R instance installed on your local machine, you can play with some of the custom R visuals. The catalog views could be used in a similar way to generate power […]

Read More

Web Scraping With Power BI

Imke Feldmann shows how to use Power BI to scrape multiple tables from a webpage: I will present 2 methods here: Append-method: This is the obvious one and is fast for just a few tables. Add-Column-method: A bit more complicated but will be faster for a large number of tables and is also suitable for […]

Read More

Categories

April 2016
MTWTFSS
« Mar May »
 123
45678910
11121314151617
18192021222324
252627282930