Forum Discussion

anonymous_98's avatar
anonymous_98
Icon for Resolver I rankResolver I
4 years ago
Solved

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

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.
  • 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.

2 Replies

  • 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"

  • 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.