Hi guys I am struggling with this refresh speed... I am growing older waiting for it.
For the Table.Buffer I can't figure out where to include it when my main query starts with this
let
Source = Folder.Files("Z:..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])),
#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
Hi Irina,
Without seeing your whole query it's hard to say what might be the issue. Need to know the types of transformations you are doing.
Table.Buffer won't work for you on the Source step as you are loading a list of files from a folder.
Regards
Phil
