Connect to SharePoint and add MetaData such as Create Date as Column in Table

[PowerUser123]

I'm connecting to CSV files in SharePoint and for some reason the Source.Name column does not appear in my table. I'm not sure if it's because there already is a column called "Name" in my underlying data?

I use the following way to import files from SharePoint so I don't have all the helper queries:

FxRead2 Function:

(myFile as binary) => Csv.Document(myFile, [Encoding=1252])

Query:

let
    Source = SharePoint.Files("https://somecompany.sharepoint.com/sites/dept/", [ApiVersion = 15]),

  #"Removed Other Columns" = Table.SelectColumns(Source, {"Content"}),
  Content = List.Transform (#"Removed Other Columns"[Content], Binary.Buffer),
  Custom1 = List.Transform( Content, fxRead2),
  Custom2 = Table.Combine( Custom1 ),

Is there a way I can alter either the query or function above so that when the table is generated, it creates another column for some of the metadata columns such as Create Date?

[v-yalanwu-msft]

Hi， @PowerUser123 ；

You could refer to this post.

https://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.