Import Folder long path

Hi robofski ,

1. Create a parameter in Power query make the parameter is \\server\share\folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder\another folder.

2. Edit the M code in your Advanced editor to replace the file pate to parameter.

let
    Source = Folder.Files(""&Parameter1),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from New folder", each #"Transform File from New folder"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File from New folder"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from New folder", Table.ColumnNames(#"Transform File from New folder"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Date", type date}, {"cat", type text}, {"Sales", Int64.Type}})
in
    #"Changed Type"