Steve-DataCoura's avatar
Steve-DataCoura
Icon for Advocate I rankAdvocate I
8 months ago
Status:
Needs Votes

Provide basic features for working in the Advanced Editor in dataflows - e.g. search, replace, intel

Please recognize that developers actually use the Advanced Editor in dataflows to modify the M-Code and provide at least BASIC support features for this.

 

- Find, Replace, Replace All

- Intellisense

 

And break up the script into multilple lines adding a step using the UI.  

 This format is very difficult to read:

  #"Merged queries" = Table.NestedJoin(#"Renamed columns", {"Company", "Customer No"}, #"Renamed columns", {"Company", "Customer No"}, "Renamed columns", JoinKind.LeftOuter)
 
 This is better-
   #"Merged queries" = Table.NestedJoin(#"Renamed columns",
      {"Company", "Customer No"}, #"Renamed columns",
      {"Company", "Customer No"}, "Renamed columns",
          JoinKind.LeftOuter)
 
People may have different opinions about where to add the line breaks in the code - but I guarantee you that if you asked 10 M-code designers, none of them would think that putting everthing in a single line is the best option.
Data Factory | Dataflow

1 Comment

Recent ideas