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!

[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!