Avoiding helper queries / functions - Power Query

[ronaldbalza2023]

Hi, I am using folder connection and wondering how to avoid this helper queries to show up? Thanks in advance 🙂

let
    Source = Folder.Files("folder\files"),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Column1", Int64.Type}, {"Column2", Int64.Type}, {"Column3", type text}, {"Column4", type text}, {"Column5", Int64.Type}, {"Column6", type date}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", Int64.Type}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", Int64.Type}, {"Column18", type text}, {"Column19", type text}, {"Column20", type text}, {"Column21", Int64.Type}, {"Column22", Int64.Type}, {"Column23", type text}, {"Column24", type text}, {"Column25", type date}, {"Column26", type date}, {"Column27", type date}, {"Column28", type text}})
in
    #"Changed Type"

[amitchandak]

@ronaldbalza2023 , refer these old solution

https://community.powerbi.com/t5/Power-Query/Avoid-many-quot-Functions-amp-Helper-Queries-quot-from-...

https://community.powerbi.com/t5/Power-Query/Avoid-Helper-Queries/m-p/1752185