Power BI
NewPower Query Editor Applied Steps support for nested Let In expressions and Inline functions
Ryan Beesley on 26 Jan 2019 07:55:00
Consider a query like this:
let
foo = (rec) =>
let
bar = rec
in
bar,
baz = foo("bat")
in
baz
Evaluated, baz = "bat". In the Applied steps, this result can be seen, but the inline function just provides a way to Enter Parameter and provides no way to see what has happened to values passed in.
This could be remedied by allowing the user to enter parameters and then show them in the applied steps grouped with the function. Expanding the function would then allow the user to see those values propagate through the function.
As a nice side-effect of providing this feature, it could also be used for queries that are just a function as a way of debugging them.