Skip to main content

Power BI

New

Power Query Editor Applied Steps support for nested Let In expressions and Inline functions

Vote (1) Share
Ryan Beesley's profile image

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.