Not all Power Query Steps are shown under the Applied Steps TAB

[anonymous_98]

Hi All,

so here is the scenario.

Issue: not all the steps of my power query code are visible in the Applied steps TAB.

Code1: 

let
    a = 1,
    b = 2
in
    a + b

we are getting below Applied Steps for the Code1

what is expected number of steps we should get under the Applied Steps TAB?

1. we should get 3 steps under the Applied Steps TAB.

[amitchandak · Accepted solution]

@anonymous_98 , I have done a small change and I am able to see all steps

let
a = 1,
b = 2,
c= a+b
in
c

avoid calculation in "in"

[anonymous_98 · Accepted solution]

Hey @anonymous_98,

here is the solution to your issue.

Use Below power query code to get the expected correct number of steps under the Applied Steps TAB.

Code2: 

let
    a = 1,
    b = 2,
    result = a + b
in
    result

we are getting below applied steps for Code2:

1. so what should we do to get the correct applied steps ?
1. always save your end result in a variable and display that variable in the output.
2. in our case, we saved the results into the variable result and then displayed the result variable in the output.
   

[amitchandak · Accepted solution]

@anonymous_98 , I have done a small change and I am able to see all steps

let
a = 1,
b = 2,
c= a+b
in
c

avoid calculation in "in"