Forum Discussion
Can I keep the file name column when Combine files in a folder with Power query?
When I click into the binary content, I will lose the file name column, like the picture below. What can I do to keep the file name column ?
@@mengshen
Simple after combining binary in Power Query replace
"= Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (2)"})"
with
"= Table.SelectColumns(#"Renamed Columns1", {"Source.Name","Folder Path", "Transform File (2)"})"