Forum Discussion
Power Query M list all functions with = #shared
I just saw the PASS BA Data Preparation in Power BI presentation by @Rad_Reza and i was really impressed with the #shared function. Just try it out open a blank query and type = #shared and you ...
Clearly late to the post (first was 2016!) but I saw this method in a Youtube video and tried it. Works a treat but suggest adding a convert to table step, sorting on Name and renaming this object to 0_Query so it is first in the list and not mistaken. Any other active query objects will also be there but you could filter out Value = Table. YMMV
let
Source = #shared,
#"Converted to Table" = Record.ToTable(Source),
#"Sorted Rows" = Table.Sort(#"Converted to Table",{{"Name", Order.Ascending}})
in
#"Sorted Rows"