Importing from Folder

Question

Hello

I want to import multiple files form the same folder. I've added a custom column, but this is giving me an error. M code and errors are ...

Source = Folder.Files("E:\StudentTest"),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Content", "Name"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "ExcelData", each Excel.Workbook[Content])
in
#"Added Custom"

Expression.Error: We cannot apply field access to the type Function.
Details:
Value=[Function]
Key=Content

Any advice
much appreciated.
Ron

Answer 1

Hi @ron barlow

You're missing a closing parenthese after Excel.Workbook. The following should do what you want:

let  
    Source = Folder.Files("E:\StudentTest"),  
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Content", "Name"}),  
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "ExcelData", each Excel.Workbook([Content]), type table)  
in  
    #"Added Custom"  

Answer 2

Thanks you for the quick reply, which has worked.

I used the ribbon to build the Custom column (I didn't type it manually), so I'm not sure why PBI didn't add the missing piece of M code?