Skip to main content

Power BI

Needs Votes

In Power Query editor, Applied steps, please make "View native query" available even on the first step

Vote (2) Share
Pär Adeen's profile image

Pär Adeen on 01 Sep 2020 18:38:36

By some reason, "View native query" is disabled in the first applied step. This happens e.g. when referring a base query.
There's probably a logic being valid in some cases that the first applied step can not view a native query, but it's not valid in all case.

E.G.

let
First = #"BaseSQLQuery"
in
First

With the code above, "View native query" is not available

But with the code below, "View native query" is available

let
First = #"BaseSQLQuery"
Dummy = First
in
Dummy