Capture Execution time for Power Query object

[abpgupta]

Hi All

Is there any way to capture execution time between Power Query steps starting from source till end of last step?

Thanks for inputs!

[PwerQueryKees]

@Sahir_Maharaj 's solution will not work.

M statements are not evaluated in the order they are written, they are evaluated when needed...

Look at my post here: I created some M functions to time the execution o... - Microsoft Fabric Community

[Sahir_Maharaj]

Hello @abpgupta,

In the Advanced Editor, you will see the M code that defines your query. Insert the following code at the beginning of the query:

let
    StartTime = DateTime.LocalNow(),
    Source = [Your Source],
    ...[Your Query Steps]...
    EndTime = DateTime.LocalNow(),
    ExecutionTime = EndTime - StartTime
in
    ExecutionTime

This will capture the start time, end time and execution time of your query in the format of DateTime. 

Let me know if you might need further assistance.

[abpgupta]

I had done this but both times came same. I am looking for time to fetch data.  Thank you!